SQL SELECT Statement

SELECT * FROM users; # select all columns
SELECT name, email FROM users; # specific columns
SELECT DISTINCT country FROM users; # unique values

SELECT name AS full_name FROM users; # alias with AS
SELECT name full_name FROM users; # alias without AS

SELECT * FROM users LIMIT 10; # first 10 rows
SELECT * FROM users LIMIT 10 OFFSET 20; # skip 20, get 10

SELECT * FROM users ORDER BY name; # ascending (default)
SELECT * FROM users ORDER BY name DESC; # descending
SELECT * FROM users ORDER BY age DESC, name; # multiple columns

SELECT price * quantity AS total FROM orders; # calculation
SELECT CONCAT(first_name, ' ', last_name) AS name FROM users; # concatenation