Query with WHERE, LIKE, BETWEEN, IN, IS NULL, ORDER BY, LIMIT, and OFFSET for pagination.
SELECT Queries
SELECT * FROM users;
SELECT id, name, email FROM users;
SELECT DISTINCT country FROM users;
-- WHERE conditions
SELECT * FROM users WHERE is_active = 1;
SELECT * FROM users WHERE age BETWEEN 18 AND 30;
SELECT * FROM users WHERE name LIKE 'Al%';
SELECT * FROM users WHERE email LIKE '%@gmail.com';
SELECT * FROM users WHERE id IN (1, 3, 5, 7);
SELECT * FROM users WHERE bio IS NULL;
SELECT * FROM users WHERE bio IS NOT NULL;
-- ORDER BY
SELECT * FROM users ORDER BY created_at DESC;
SELECT * FROM users ORDER BY name ASC, age DESC;
-- LIMIT and OFFSET (pagination)
SELECT * FROM users LIMIT 10;
SELECT * FROM users LIMIT 10 OFFSET 20; -- page 3