Multiple choice technology web technology

Which are the following are illegal Queries while using group Functions.

  1. You cannot use the WHERE clause to restrict groups.

  2. You cannot use the HAVING clause to restrict groups

  3. You cannot use group functions in the WHERE clause

  4. None of these
Reveal answer Fill a bubble to check yourself
A,C Correct answer
Explanation

When using group functions (aggregate functions like COUNT, SUM, AVG), you cannot use the WHERE clause to restrict groups: use HAVING for that. Also, group functions cannot appear in the WHERE clause because WHERE filters individual rows before grouping. Option B is incorrect because HAVING is specifically designed to restrict groups after aggregation.

Keep practicing — related questions