Code Snippets
MySQL Snippets
The joins and the gotchas, copy-pasteable - the queries that are easy to get subtly wrong and the reasons they go wrong.
Everything in MySQL Snippets
09/27/2026
MySQL: get the latest row per group with ROW_NUMBER()
Get the latest row per group in MySQL 8+ with ROW_NUMBER(). Why MAX() subqueries and self-joins return duplicates on ties, and the tie-breaker to add.