WHERE
Filters records based on specified conditions.
Syntax
sql
SELECT * FROM table WHERE condition;Example
sql
SELECT * FROM products
WHERE price < 50
AND in_stock = true
AND category IN ('electronics', 'gadgets');Filters records based on specified conditions.
SELECT * FROM table WHERE condition;SELECT * FROM products
WHERE price < 50
AND in_stock = true
AND category IN ('electronics', 'gadgets');