Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 60 of 91

Grouping Records, Joins in SQL — Question 1

Back to all questions
1
Question

Question 1

What is the difference between HAVING and WHERE clause ?

Answer
HAVING clauseWHERE clause
HAVING conditions are applicable to groups formed by GROUP BY clause.WHERE conditions are applicable to individual rows.
HAVING conditions can include aggregate functions.WHERE conditions cannot include aggregate functions.
It allows conditions to be applied to grouped data.It filters rows based on specified conditions.