Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 56 of 90

Querying Using SQL — Question 6

Back to all questions
6
Question

Question 6

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.