WHEN DO YOU USE WHERE CLAUSE AND WHEN DO YOU USE HAVING CLAUSE?

Sumit Kesarwani

Total Post:782

Points:3910
Posted by  Sumit Kesarwani
MYSQL 
 1263  View(s)
Ratings:
Rate this:
  1. Sumit Kesarwani

    Post:782

    Points:3910
    When do you use WHERE clause and when do you use HAVING clause?

     The WHERE condition lets you restrict the rows selected to those that satisfy one or more conditions.Use the HAVING clause to restrict the groups of returned rows to those groups for which the specified condition is TRUE

Answer

NEWSLETTER

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