New posts in Groupwise Maximum

Optimize groupwise maximum query

LEFT JOIN only first row

SQL select only rows with max value on a column