Answered Questions

  • Aug 29 2004
    10:49 PM
    10129
    23

    When do you use WHERE clause and when do you use HAVING clause?

    HAVING clause is used when you want to specify a condition for a group function and it is written after GROUP BY clause. The WHERE clause is used when you want to specify a condition for columns, single row functions except group functions and it is written before GROUP BY clause if it is used.

    Mushtaque

    • Aug 25th, 2013

    WHERE clause can contains condition that must be met and should directly follow the from clause. And HAVING clause can precede GROUP BY clause,but it is more logical to declared in after GROUP BY clau...