Question

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

Answer 1

The SQL keyword used with GROUP BY to select groups meeting specified criteria is HAVING, which filters groups after grouping.

Step-by-step explanation:

In an SQL query, the SQL keyword used with GROUP BY to select groups that meet specified criteria is HAVING. While the WHERE clause is used to filter rows before any grouping occurs, the HAVING clause is designed to filter groups after the GROUP BY has been applied. This is crucial for scenarios where you want to apply a condition to a group aggregate rather than individual rows.