Tag Archives: having clause vs where clause sql server

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

WHERE CLAUSE:- An aggregate may not appear in the WHERE clause. The having clause is an additional filter to the where clause. HAVING CLAUSE:- An aggregate may appear in the HAVING clause. Example:- Emp Bonus Anuraag 9000 Anuraag 15000 Hitesh 5000 Hitesh 6000 Nitesh 7000 Nitesh 8000 Ritvij 8000 Ritvij 10000 Where Clause Above query Continue Reading…