Question

In an SQL query, which SQL keyword is used with GROUP BY to select groups meeting specified criteria?

a) WHERE

b) HAVING

c) IN

d) AND

Answer 1

The SQL keyword used with GROUP BY to select groups meeting specified criteria is HAVING.

Step-by-step explanation:

The SQL keyword used with GROUP BY to select groups meeting specified criteria is HAVING.

The HAVING keyword is used in conjunction with the GROUP BY clause to filter the groups based on specified conditions.

For example, if you want to select groups where the count of records in each group is greater than a certain value, you can use HAVING along with an aggregate function like COUNT.