WHERE Clause

The WHERE clause is used to filter rows based on a condition.

SELECT * FROM employees WHERE department_id = 50;

Operators like =, <, >, !=, LIKE, IN are commonly used.