WHAT IS THE DIFFERENCE BETWEEN A HAVING CLAUSE AND A WHERE CLAUSE?

Sumit Kesarwani

Total Post:782

Points:3910
Posted by  Sumit Kesarwani
C# 
C#
 1034  View(s)
Ratings:
Rate this:
  1. Sumit Kesarwani

    Post:782

    Points:3910
    What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

    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.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!