Which SQL clause filters rows based on a condition?

Which SQL clause filters rows based on a condition?

• A. SELECT
• B. GROUP BY
• C. WHERE
• D. ORDER BY

Answer: (C)

Filtering rows based on a condition is done with a clause that applies a boolean test to each row and includes only those that satisfy the test. This is the WHERE clause. It typically appears after the FROM clause and before any grouping or ordering clauses, and you can use expressions like price < 50, status = 'active', or category = 'books'. The other options serve different purposes: SELECT determines which columns to return, GROUP BY organizes rows into groups for aggregation, and ORDER BY sorts the final results.

Filtering rows based on a condition is done with a clause that applies a boolean test to each row and includes only those that satisfy the test. This is the WHERE clause. It typically appears after the FROM clause and before any grouping or ordering clauses, and you can use expressions like price < 50, status = 'active', or category = 'books'.

The other options serve different purposes: SELECT determines which columns to return, GROUP BY organizes rows into groups for aggregation, and ORDER BY sorts the final results.