WHERE Clause and Filtering

WHERE filters records based on a condition.

SELECT * FROM users WHERE age > 18;

• AND: Combine conditions
• OR: At least one condition is true
• NOT: Negates a condition

Example:

SELECT * FROM users WHERE age > 18 AND city = 'Delhi';