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

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

960

What is scalar user-defined function?

1074

what is denormalization and when would you go for it? : Sql server database administration

1153

Explain what stored procedure sp_replcounters is used for? : sql server replication

1488

What are trace flags?

1009

Why is normalisation important?

927

Describe how to use linked server?

991

How can we improve performance by using SQL Server profiler?

1032

What is SQL Server?

1191

What stored by the msdb?

979

How do I find the sql server instance name?

954

What are sub reports?

201

What is difference between rownum and row_number?

944

Where to find ntwdblib.dll version 2000.80.194.0?

945

What are the different types of stored procedures?

1099