Tags / greatest-n-per-group
Optimizing Your Data: How to Filter by Maximum Time for Each Day and Store in TrickleData
SELECT DISTINCT ON (label) * FROM products ORDER BY label, created_at DESC;
Understanding the Limitations of Min(date) in SQL Case Statements: Workarounds without Window Functions
Oracle SQL Query to Extract Last Entry Date per Category
Optimizing Record Selection in MySQL for Minimum Date Value While Ensuring Specific Column Values