HAVING CLAUSE is used for evaluating a condition with an aggregate functi

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

Question Posted / srinivas

Answer Posted / srinivas

HAVING CLAUSE is used for evaluating a condition with an
aggregate function, i.e., GROUP BY whereas WHERE CLAUSE is
used for general conditions.

Is This Answer Correct ?

35 Yes

4 No

Please Help Members By Posting Answers For Below Questions

what are different types of raid configurations? : Sql server database administration

1056

What is query optimization process?

1012

What is 2nf normalization form?

1136

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2752

how would you improve etl (extract, transform, load) throughput?

1026

What are the different types of join?

1173

How can you control the amount of free space in your index pages?

1057

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

1194

what is isolation level at dead lock?

2151

What is the recommended total size of your memory optimized tables?

966

Does partitioning help performance?

935

Differentiate between a local and a global temporary table?

954

What is checkpoint in sql server?

1160

What is table-valued sub query?

967

What is the size of transaction log file?

931