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

what is spatial nonclustered index

973

Why truncate is ddl command?

1042

You want to use a perspective in an mdx query. How do you select the perspective?

239

What stored by the master? : sql server database administration

1086

What is the difference between function and stored procedure in sql server?

1043

What are key, name and value columns of an attribute? : sql server analysis services, ssas

988

What do you mean by an execution plan?

1093

What are the steps to insert a table?

924

What are “lost updates”?

982

Explain the disadvantages/limitation of the cursor?

940

what is an index? : Sql server database administration

958

What are a scheduled jobs?

942

what are the different ways to return the rowcount of a table?

978

What is rtm version in sql server?

1025

Write a query for primary key constraint with identity key word?

1011