Get the Maximum (Max) value BUT separate for EACH item
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
Subject
Written By
Posted
Get the Maximum (Max) value BUT separate for EACH item
February 10, 2019 07:00AM
February 10, 2019 08:09AM
February 10, 2019 12:46PM
February 10, 2019 01:15PM
February 10, 2019 07:24PM
Sorry, you can't reply to this topic. It has been closed.
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.