In an SQL query,which SQL keyword is used with GROUP BY to select groups meeting specified criteria?
A)AND
B)WHERE
C)HAVING
D)IN

Question

Quizplus · Accepted Answer

The keyword used with GROUP BY to select groups meeting specified criteria is HAVING. This is because WHERE is used to filter individual rows, and GROUP BY is used to group rows based on a common value in a particular column. The HAVING clause is used to filter or apply conditions to groups of rows that have been formed using GROUP BY. It allows you to select only those groups that meet certain criteria based on aggregate functions such as SUM, AVG, COUNT, etc. Therefore, the correct answer is C) HAVING.

In an SQL Query,which SQL Keyword Is Used with GROUP