MySQL Forums
Forum List  »  General

Get the Maximum (Max) value BUT separate for EACH item
Posted by: Alexandre Salomé
Date: February 10, 2019 07:00AM


I am needing help exporting a MySQL report.
I have a base of sellers and sales. I need to get the value of the biggest sale (MAX) of each seller. (and not a bigest value of all them).

Today I use the following syntax to fetch the values ​​from the table:

select, REPLACE (JSON_EXTRACT (A.attributes, '$ .Sale'), '.', ',')
from tc_sales A
join tc_sellers B
fixtime between '2018-09-01' and '2018-09-30'
limit 18000000000000000000;

Thanks for the future help

Options: ReplyQuote

Written By
Get the Maximum (Max) value BUT separate for EACH item
February 10, 2019 07:00AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.