What is the Difference between a HAVING clause and a WHERE clause?
Written by Agetinfence Monday, 09 January 2012 17:33
They specify a search condition for a group or an aggregate. But the difference is that HAVING can be used only with the SELECT statement. HAVING is typically used in a GROUP BY clause. When GROUP BY is not used, HAVING behaves like a WHERE clause. Having Clause is basically used only with the GROUP BY function in a query, whereas WHERE Clause is applied to each row before they are part of the GROUP BY function in a query.
| < Prev | Next > |
|---|