How to find the max row per group in SQL without subqueries – Xaprb:
A while ago I wrote about how to select the first, minimum, maximum or least row per group in SQL. This article shows how to solve this problem without subqueries.
Like many SQL problems, the key to understanding the solution is to rephrase the English question to make it easy to translate into SQL.