Multiple choice technology databases

WHERE clause is used to restrict groups

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

WHERE clause filters individual rows before any grouping occurs. HAVING is used to filter groups after GROUP BY is applied. The statement claims WHERE restricts groups, which is incorrect - it restricts rows, not groups.

AI explanation

The WHERE clause filters individual rows before any grouping or aggregation happens, so it operates on raw table data. Restricting or filtering groups (formed by GROUP BY, often with aggregate conditions) is the job of the HAVING clause instead. That's why the statement, which attributes group-restriction to WHERE, is false.

Keep practicing — related questions