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

Understanding SQL Order By: Mastering IsNumeric() for Non-Numeric Data Handling

Handling Null Values in MySQL Order By Clause: Effective Strategies for Accurate Results

Alternating Category Order While Maintaining Groupings Based on Question ID in SQL