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

Question

Sumit Kesarwani · Answer

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

interview

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

Can you answer this question?

1 Answers