What is the major difference between (Having and Where)

Question

Hi.. i have a question that what is the difference between HAVING and WHERE? what ever I have read articles i did not get proper answer... can any one define please..

Pravin More · Answer

Hi Kanhialal major difference between (Having and Where) is having is used against aggregate function(like sumcount etc) and where clause not allow use of aggregate function like e.g select ID from Table_name group by ID having count(assets) >5 hope you get answer. Thanx pravin.

Hemant Kumar · Answer

You can have WHERE without HAVING you can have HAVING without WHERE you can have both WHERE and HAVING and you can have neither WHERE nor HAVING. But you can't have HAVING without grouping even if the group consists of the entire result set. A good example of the difference between WHERE and HAVING is given in my earlier answer Why WHERE cannot be used after GROUP BY .

Kanhialal kk · Answer

an other question sir.. can you help me to create trigger on a table with query... please.