How to select the first/least/max row per group in SQL: This has saved me on a recent project. Very good to know how to limit results from a SQL JOIN with one-to-many relationship.

(Via Xaprb.)