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

Hello,

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 B.name, REPLACE (JSON_EXTRACT (A.attributes, '$ .Sale'), '.', ',')
from tc_sales A
join tc_sellers B
ONDE
fixtime between '2018-09-01' and '2018-09-30'
limit 18000000000000000000;

Thanks for the future help

Options: ReplyQuote


Subject
Written By
Posted
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.