SELECT Statements in SQL
From the SQL cheat sheet · SELECT & Filtering · verified Jul 2026
SELECT Statements
Retrieve data with filtering, sorting, and limiting.
sql
-- Select all columns
SELECT * FROM users;
-- Select specific columns
SELECT name, email FROM users;
-- WHERE filtering
SELECT * FROM users WHERE age > 18;
SELECT * FROM users WHERE city IN ('NYC', 'LA');
SELECT * FROM users WHERE age BETWEEN 25 AND 35;
-- Sorting
SELECT * FROM users ORDER BY name ASC;
SELECT * FROM users ORDER BY age DESC, name ASC;💡 Use column aliases (AS) to rename output columns — makes results more readable
⚡ LIMIT syntax varies: MySQL/PostgreSQL use LIMIT, SQL Server uses TOP, ANSI uses FETCH
📌 IS NULL is the only way to check for NULL — "= NULL" does not work
🟢 ORDER BY defaults to ASC — only add DESC when you need descending order
selectwhereorder-bylimit