We can't use Where clause with aggregate function and Having clause a

What is the difference between having and where clause?

Question Posted / vinay singh

Answer Posted / vinay singh

We can't use Where clause with aggregate function and Having
clause always use with aggregate function.

**Vinay Singh

Is This Answer Correct ?

6 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Tell me about builtinadministrator?

945

Is null vs coalesce?

814

What is a non equi join?

911

What are the different types of stored procedures?

1064

What is sql sandbox in sql server?

1144

How to stop log file growing too big?

952

Does hive support indexing?

905

Explain differences between web edition and business edition?

119

What is a trigger what are the advantages of trigger?

912

What is dirty page?

918

Ways to improve the performance of a SQL Azure Database?

123

Explain the use of keyword with encryption. Create a store procedure with encryption?

892

Detail about query optimizer?

1031

How can sql server instances be hidden?

891

How to call a function from a stored procedure in SQL Server ?

952