oracle mysql select max and return multiple values

Code and details:
another example on max N per group

Mysql group by column and return N max/min rows per group:
* get max per group
* get minimum per group
* use additional constraints
* return N per group

---------------------------------------------------------------------------------------------------------------------------------------------------------------
If you really find this channel useful and enjoy the content, you're welcome to support me and this channel with a small donation via PayPal and Bitcoin.

Bitcoin: 1DBZu6N9JTpRDdc9QChLZnX3v2iVRaQ4ym

Programming is a fun! :)