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

Can you always create a cache of a report?

115

How can I know what locks are running on which resource?

494

what changed between the previous version of sql server and the current version? : Sql server database administration

513

How do indexes help, types?

546

What is 3nf normalization form?

559

How do I setup a sql server database?

536

Explain for xml explicit mode?

556

What are the different types of replication are there in sql server 2000?

558

How to rebuild master databse?

655

How to round a numeric value to a specific precision?

569

Explain insert into select statement?

518

What is @@error in sql?

616

Can we take the full database backup in log shipping?

533

Does sql server 2016 have ssms?

505

What is the largest component inside a field?

525