Which clause is used to filter data after the FROM clause?

• A. Where
• B. From
• C. Select
• D. Group By

Answer: (A)

Filtering rows in a query is done with the WHERE clause, which comes after listing the tables in the FROM clause. It sets a condition, and only rows that meet that condition are kept in the result. For example: SELECT * FROM employees WHERE department = 'Sales'; Here, the data source is defined first with FROM, then WHERE filters that set of rows. The other parts have different roles: FROM specifies the tables, SELECT chooses which columns to return, and GROUP BY groups rows after filtering (with HAVING used to filter those groups).