K
K
Kira_79792021-02-28 13:58:11
SQL query optimization
Kira_7979, 2021-02-28 13:58:11

Query 1s or sql for each Counterparty the minimum date when the amount of sales was maximum?

It is required to write a query that returns for each Counterparty the minimum date when the sales amount was maximum, and the maximum date when the sales amount was minimum, as well as the sales amounts for these dates.
I’m wise for the second day. It’s not a problem to find a separately specified Counterparty. But for all counterparties, one request does not work. Everything was tested: JOIN, Subquery, Temporary tables, etc. Does not help.
At least I have an idea.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question