Tutorials › PostgreSQL Essentials › ORDER BY and LIMIT

ORDER BY and LIMIT

4 min read

ORDER BY sorts results ASC (default) or DESC. LIMIT n returns only n rows. OFFSET n skips n rows for pagination. Combine them: LIMIT 20 OFFSET 40 gets page 3 with 20 items per page.

Sorting and Limiting

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

-- Get top 5 oldest users
SELECT * FROM users ORDER BY age DESC LIMIT 5;

-- Pagination
SELECT * FROM users LIMIT 10 OFFSET 20; -- page 3

← WHERE Clause Next: UPDATE and DELETE →

Quick Access

ORDER BY and LIMIT

Sorting and Limiting