Where clause is used prior the grouping of data, where as Having is used a

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

Question Posted / saisri

Answer Posted / saisri

Where clause is used prior the grouping of data,
where as Having is used after grouping the result of the
data.

Is This Answer Correct ?

1 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Define views.

1017

What is the significance of null value and why should we avoid permitting null values?

989

why would you call update statistics? : Sql server database administration

1091

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

943

Is mysql better than sql server?

1065

What is partition index in sql server?

1122

How do I find the default sql server instance?

945

role of sql sever 2005 in database rather than any other database

1944

How to run sql server 2005 books online on your local system?

961

What Is Rdbms?

1164

What is the difference between for auto and for nested?

1005

Explain how many types of relationship?

1031

Explain transaction server explicit transaction?

936

What is the Difference Between Primary and Foreign Key?

1007

What is the maximum size of a row in sql server?

969