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

Explain the purpose of indexes?

900

How to create an index on a view?

987

how to create a scrollable cursor with the scroll option? : Sql server database administration

1025

what type of index will get created after executing the above statement? : Sql server database administration

920

How to disable a login name in ms sql server?

1061

What do you mean by authentication modes in sql server?

1028

What is the difference between row_number and dense_rank?

826

What is join and name different type of joins?

974

What is SQL Azure Fabric?

108

Explain indexing and what are the advantages of it?

963

Tell me what is the stuff and how does it differ from the replace function?

933

What is stored in the mssqlsystemresource database? : sql server database administration

987

How would we use distinct statement? What is its use?

1023

Is sql server free?

870

What are the main differences between #temp tables and @table variables and which one is preferred?

1013