Interview Questions Answers in SQL Server

thirumal

{ City } delhi
< Country > india
* Profession *
User No # 4503

Total Questions Posted # 0
Total Answers Posted # 1

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 9
Users Marked my Answers as Wrong # 0

Questions / { thirumal }

Questions Answers Category Views Company eMail

Answers / { thirumal }

Question { 10330 }

What is the difference between having and where clause?

Answer

where clause used to impose conditions in any dml operation
ex:
selct * from emp where empid=10
having clause used to impose conditions on group data
ex:

select sum(sal),avg(sal),count(*) from emp
having avg(sal)>2000

Is This Answer Correct ?

9 Yes

0 No