Most asked top Interview Questions and Answers | Online Test | Mock Test
Prepare Interview
Ask Question

Mock Exams

Make Homepage

Bookmark this page

Subscribe Email Address

Question: Explain the purpose of the HAVING clause.
Answer: The HAVING clause is used in combination with the GROUP BY clause to filter the results of aggregate functions based on specified conditions.

Example:

SELECT column, COUNT(*) FROM table GROUP BY column HAVING COUNT(*) > 1;
Is it helpful? Yes No

Most helpful rated by users:

©2025 WithoutBook