PostgreSQL Order By Two Columns with Nullable Last

Sorting by Condition Using MySQL Regular Expressions and Conditional Aggregation

Understanding ORDER BY Clause in SQL: A Deep Dive

Database Schema Design Considerations for Large Tables with Grouping and Ordering: A Step-by-Step Guide to Efficient Performance and Data Integrity

Sorting Characters to Force SQL Sort: Using Concatenation with Characters for Custom Sorting

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