Back

SELECT queries

SELECT is how you read data from a database. It's the most used SQL command: you'll write it constantly.

-- Get all columns
SELECT * FROM users;

-- Get specific columns
SELECT name, email FROM users;

-- With a condition
SELECT * FROM users WHERE age > 18;

-- Sort results
SELECT * FROM users ORDER BY name ASC;

-- Limit results
SELECT * FROM users LIMIT 10;

-- Combined
SELECT name, age FROM users
WHERE age > 18
ORDER BY age DESC
LIMIT 5;

Roadmap