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 a partition function in sql server?

1131

How to add more data to the testing table in ms sql server?

1083

How do I manually uninstall an instance of sql server 2016?

1038

What is the difference between a function and a trigger?

1080

What are constraints in microsoft sql server?

1125

What is acid db?

886

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1071

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

942

What are acid properties of transaction?

949

Explain few examples of RDBMS?

1037

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

1066

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

955

How to drop an existing table?

1000

What guidelines should be followed to help minimize deadlocks?

940

Explain why variables called the most powerful component of ssis?

1089