what is Difference between Having and Where clause?

Question Posted / guest

Answers were Sorted based on User's Feedback

what is Difference between Having and Where clause?..

Answer / chandrakala

Having clause is used for filtering grouped data and where
clause is used for filtering rows.

Is This Answer Correct ?

33 Yes

0 No

what is Difference between Having and Where clause?..

Answer / ganesh

where clause check a condition & having clause is use in
group by clause

Is This Answer Correct ?

12 Yes

2 No

what is Difference between Having and Where clause?..

Answer / nrapendra

where clause filter the data before gruop by clause and
having clause clause filter the data after group by clause

Is This Answer Correct ?

9 Yes

0 No

what is Difference between Having and Where clause?..

Answer / joe

When we used group by that time only we can use having. But without group by we can use having.
Only grouped column have used in having condition

Is This Answer Correct ?

0 Yes

1 No

what is Difference between Having and Where clause?..

Answer / tanmoy

We can use arithmetic operator in having clause but it is
not possible for where clause..

Is This Answer Correct ?

0 Yes

5 No