Multiple choice technology databases

What is true about WHERE clause ?

  1. A WHERE clause can be used to restrict rows only.

  2. A WHERE clause CANNOT be used in a query if the query uses a HAVING clause.

  3. WHERE clause can be used to restrict both rows and groups.

  4. WHere clause filters the columns from the output
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The WHERE clause restricts rows from the database table before group formation, while HAVING is used to restrict groups. WHERE cannot filter columns, which is the function of the SELECT clause, nor does it conflict with HAVING.

Keep practicing — related questions