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

What are difference between Cluster index and Non-Cluster index?

1131

Explain hostprotectionattribute in sql server 2005?

1075

What is dimension table? : sql server analysis services, ssas

1065

What is sqlcmd?

1136

please differentiate between delete and truncate?

1038

How many types of triggers in sql server?

1089

How do I find information about the install locations for the various instances running on a computer?

1124

How can windows applications connect to sql servers via odbc?

1178

What are scalar functions in sql?

1208

What is Extended user-defined?

1029

Who is the owner of a schema in ms sql server?

1116

What is ms sql server reporting services?

1123

What are the advantages of stored procedure in sql server?

931

What does it mean to invest in the index?

1019

Difference between primary key and clustered index?

1062