Home » MCQs » SQL MCQs » SQL Statements and Clauses MCQs

What is the difference between HAVING and WHERE clause?

18. What is the difference between HAVING and WHERE clause?

1. HAVING clause is used in column operation whereas WHERE clause is used in row operation.
2. HAVING clause is post-filter whereas WHERE clause is pre-filter.
3. HAVING clause filters the groups whereas WHERE clauses filter the single record of the table.
4. All of the above

Answer: D) All of the above

Explanation:

The differences between HAVING and WHERE clauses are:

1. HAVING clause is used in column operation whereas WHERE clause is used in row operation.
2. HAVING clause is post-filter whereas WHERE clause is pre-filter.
3. HAVING clause filters the groups whereas WHERE clauses filter the single record of the table.