What is the difference between a HAVING CLAUSE and a WHERE CLAUSE

Q

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

✍: Guest

A

You can use Having Clause with the GROUP BY function in a query and WHERE Clause is applied to each row before they are part of the GROUP BY function in a query.

2007-10-25, 4649👍, 0💬