SELECT Basics

The SELECT statement is used to query data from databases.

Simple SELECT

-- Select all columns
SELECT * FROM users;

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

-- Select with alias
SELECT name AS full_name, email AS contact_email
FROM users;

WHERE Clause

-- Filter with WHERE
SELECT * FROM users WHERE age > 25;

-- Multiple conditions
SELECT * FROM users
WHERE age > 25 AND country = 'USA';

-- OR condition
SELECT * FROM users
WHERE age < 18 OR age > 65;

ORDER BY

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

-- Sort descending
SELECT * FROM users ORDER BY created_at DESC;

-- Multiple columns
SELECT * FROM users
ORDER BY country ASC, name ASC;

LIMIT

-- Limit results
SELECT * FROM users LIMIT 10;

-- Limit with offset
SELECT * FROM users LIMIT 10 OFFSET 20;