Re: Nested GroupBy or for each
Use an innermost query to pick off the top 4 per campaign, see "Within-group quotas" at
https://www.artfulsoftware.com/infotree/qrytip.php.
Within-group quotas are simpler to write with a Windowing function. These funcs came into MySQL with 8.0. What's your MySQL version?
Subject
Written By
Posted
Re: Nested GroupBy or for each
October 17, 2018 09:41AM
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.