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 primary key?

947

What are the essential components of sql server service broker?

1002

What is index, cluster index and nonclustered index?

970

What is Federation and Federation Member?

What is autocommit mode in sql server?

1145

When is the use of update_statistics command?

986

What is the order by used for?

1003

How to run queries with sql server management studio express?

1070

How to create new table with "create table" statements?

1066

What are the different types of collation sensitivity?

1094

What is a fan-out query in SQL Azure?

121

What is the difference between primary key and unique constraints?

939

What is the difference between upgrade and migration in sql server?

1059

What is order of B+tree?

1093

What is the use of commit?

980