Which SQL keyword is used to apply conditions to restrict groups that appear in the results of a SELECT query that uses GROUP BY?
A) WHERE
B) HAVING
C) LIKE
D) SORT
E) DISTINCT

Question

Quizplus · Accepted Answer

The HAVING keyword is used to apply conditions to restrict groups that appear in the results of a SELECT query that uses GROUP BY. It is essentially like the WHERE keyword, but for groups rather than individual records. The WHERE keyword applies to individual records before they are grouped, while the HAVING keyword applies to groups after they have been formed. Therefore, the correct choice is B.

Which SQL Keyword Is Used to Apply Conditions to Restrict