Question Details

Detailed explanation and options for the selected question.

Which of the following statements about the SQL WHERE clause is true?

A. It filters rows based on conditions
B. It groups rows by a common value
C. It orders rows in ascending order
D. It limits the number of rows returned

Explanation:

WHERE filters rows based on conditions. GROUP BY groups rows, ORDER BY orders rows, and LIMIT restricts row count.