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

Q

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

✍: Guest

A

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.

2011-12-06, 2659👍, 0💬