where clause is used for conditional retriving but having clause is used t

What is the difference between HAVING clause and the WHERE
clause?

Question Posted / vivek kumar

Answer Posted / vivek kumar

where clause is used for conditional retriving but having
clause is used to test some condition on the group with the
help of aggregate function.

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I find query history in sql server?

875

How to write a query with a left outer join in ms sql server?

925

What is an identity?

937

What is the command used to check locks in microsoft sql server?

972

What is the command used to recompile the stored procedure at run time?

1016

Mention a few common trace flags used with sql server?

880

Can the “if update (colname)” statement be used in a delete trigger?

944

What is difference between sql and sql server?

937

What do you understand by physical_only option in dbcc checkdb?

933

What are the purposes and advantages stored procedure?

889

What is the partitioning method?

973

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1087

What are types of subqueries?

995

Tell me about pre-defined functions of sql?

1071

What is difference between count (*) and count column?

839