1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?

Question Posted / guest

Answers were Sorted based on User's Feedback



What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?..

Answer / aravind

where is used when no group by functions are used whereas
having is used when group functions are used

Is This Answer Correct ?    3 Yes 11 No

Post New Answer

More SQL Server Interview Questions

Explain subquery and state its properties?

0 Answers  

What is database replicaion? What are the different types of replication you can set up in SQL Server?

5 Answers   Aptech, HCL, Perpetual, SAIC,

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

0 Answers  

Find top Nth employee from each department in terms of salary?

13 Answers   RealPage,

What new changes are being made in SQL Server?

0 Answers   Blue Star,




How does recursive cte works in sql server?

0 Answers  

Explain data warehousing in sql server?

0 Answers  

what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

0 Answers  

How can we rewrite sub-queries into simple select statements or with joins?

0 Answers  

What language is sql server written in?

0 Answers  

What is shared lock?

0 Answers  

How can you set the threshold at which sql server will generate keysets asynchronously?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories