Get the top N rows per query

ORDER BY with LIMIT.

More SQL recipes

• Find duplicate values
• Find rows with no match in another table
• Calculate a running total
• Pivot values into columns with CASE
• Count rows per group