SELECT and filtering

SELECT picks which columns to return, WHERE filters rows, ORDER BY sorts, and LIMIT caps how many rows come back. Select only the columns you need instead of * in real apps.

SELECT name, email FROM users;

SELECT * FROM users WHERE age >= 18;

SELECT * FROM products
WHERE price < 50 AND in_stock = true
ORDER BY price DESC
LIMIT 10;

SELECT DISTINCT city FROM users;

-- Pagination: page 2, 10 per page
SELECT * FROM posts ORDER BY id LIMIT 10 OFFSET 10;

SELECT and filtering

Roadmap