Answer
WHERE filters input rows using a Boolean condition. • Rows for which the condition is true continue in the query. • False and unknown conditions are excluded. • WHERE is evaluated before grouping and aggregate filtering.
💡 SQL Example
SELECT name FROM employees WHERE active = true;
Result
Asha
Maya
⚡ Quick Revision
WHERE filters rows before grouping.