2
Reply

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

Samir Bhogayta

Samir Bhogayta

Jun 25, 2016
225
0

    Having executes after query & Where executes before query

    Mukesh Kumar
    August 31, 2017
    0

    Specifies a search condition for a group or an aggregate. 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. WHERE Clause is applied to each row before they are part of the GROUP BY function in a query. HAVING criteria is applied after the the grouping of rows has occurred.

    Samir Bhogayta
    June 25, 2016
    0