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

Question

Quizplus · Accepted Answer

The HAVING keyword is used after a GROUP BY clause to filter the groups based on specified criteria. It allows us to apply conditions to the aggregated data and filter the groups that meet those conditions. The WHERE keyword is used to filter individual rows before grouping, while the HAVING keyword is used to filter the grouped data. The AND, EXISTS, and IN keywords are used for different purposes and do not apply to filtering groups in a GROUP BY query.

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