Home / SQL / Reading data

WHERE

WHERE keeps only the rows that match a condition. Combine conditions with AND and OR. Then use ORDER BY to sort the result.

SELECT name
FROM customers
WHERE city = 'Pune' AND age > 25;

Test yourself on this