where is used when no group by functions are used whereas having is used

What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?

Question Posted / aravind

Answer Posted / aravind

where is used when no group by functions are used whereas
having is used when group functions are used

Is This Answer Correct ?

3 Yes

11 No

Please Help Members By Posting Answers For Below Questions

How do I start and stop sql server?

1006

What is function of master database?

114

How to use union to merge outputs from two queries together in ms sql server?

1050

Do you know what is fill factor and pad index?

990

Why do we need different type of parameter?

1040

What is order of B+tree?

1097

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1191

What are the different types of columns types constraints in the sql server?

1061

What is master database? : SQL Server Architecture

1002

What is the cartesian product of table?

995

Can we linked SharePoint to a SQL database?

1011

Explain full-text indexing?

967

What is database replication? What are the different types of replication you can set up in sql server?

947

What is cursor in ms sql server?

1127

Can we deploy SSRS reports on our personal website?

168