PostgreSQL — Order By

Basic Order By

SELECT * FROM users ORDER BY name;
SELECT * FROM users ORDER BY name ASC;
SELECT * FROM users ORDER BY name DESC;

Multiple Columns

SELECT * FROM users ORDER BY country ASC, name ASC;

By Expression

SELECT * FROM products ORDER BY price * quantity DESC;

By Column Number

SELECT name, age FROM users ORDER BY 2 DESC;

NULLS Handling

SELECT * FROM users ORDER BY email NULLS FIRST;
SELECT * FROM users ORDER BY email NULLS LAST;

Random Order

SELECT * FROM users ORDER BY RANDOM();

With LIMIT

SELECT * FROM products ORDER BY price DESC LIMIT 5;

Case-Sensitive

-- Case-sensitive
SELECT * FROM users ORDER BY name;

-- Case-insensitive
SELECT * FROM users ORDER BY LOWER(name);

Mini Practice

1. Sort ascending
2. Sort descending
3. Sort by multiple columns
4. Handle NULL values

Up Next

Continue with Group By — grouping results.