Home > DeveloperSection > Interviews > When do you use WHERE clause and when do you use HAVING clause?

Posted on    January-31-2014 11:57 PM

 MYSQL MYSQL 
Ratings:
 1 Answer(s)
  1106  View(s)
Rate this:

Sumit Kesarwani

Total Post:782

Points:3910
Posted on    January-31-2014 1:00 AM

 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

Don't want to miss updates? Please click the below button!

Follow MindStick