SELECT DISTINCT ON (label) * FROM products ORDER BY label, created_at DESC;

Understanding Table Ordering and Positioning in MySQL for Efficient Data Retrieval

Sorting Data by Risk Level: A Comprehensive Guide to SQL Solutions

Ordering Data by Multiple Columns: Advanced Techniques for SQL Server and Azure Databases

Understanding the Limitations of ROW_NUMBER() and Finding Alternative Solutions for Partitioned Data

Ordering Rows by First Letter and Date in SQL