Q. What is the purpose of the HAVING clause?

A
To filter rows before grouping
B
To filter grouped results after a GROUP BY clause
C
To sort the results
D
To join tables
Solution:

The HAVING clause filters the results of a GROUP BY query based on a condition, unlike WHERE which filters rows before grouping.

Entri Contact Image

Get Expert Advice for Free: Register for Your Free Consultation Now!