Having clause is used before aggregation and where clause is used before a

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

Question Posted / santosh pashupatimath

Answer Posted / santosh pashupatimath

Having clause is used before aggregation and where clause is
used before aggregation

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain where clause?

1033

Explain how would you store your query in an SSRS report or a Database server?

133

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

1045

What is exporting utility?

1086

How to view existing indexes on an given table using sp_help?

1205

How can we determine what objects a user-defined function depends upon?

1069

What are the differences between ms sql server & oracle?

1115

What is the difference between dropping a database and taking a database offline?

1218

How to deploy the Report?

140

What is the difference between index seek vs. Index scan?

1063

what is unique and xaml nonclustered index

1098

What is exporting and importing utility?

1142

What is an expensive query?

972

What is nolock hint in sql server 2008

1181

what is a check constraint?

1171