Lesson 3 of 9
WHERE & Operators
The WHERE clause filters results. Use operators like =, != or <>, >, <, >=, <=. Combine conditions with AND and OR.
SQL
SELECT * FROM users WHERE age >= 18;
SELECT * FROM products WHERE price < 50;
SELECT * FROM users
WHERE country = 'Denmark' AND age > 25;
SELECT * FROM orders
WHERE status = 'pending' OR status = 'processing';