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

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

More SQL Server Interview Questions

What is oltp (online transaction processing)?

Define the term DML, DDL and DTL?

How do I setup a local sql server database?

What is nolock hint in sql server 2008

what is a deadlock? : Sql server database administration

List some of the rules that apply to creating and using a ‘view’

What is a sub-query? When would you use one?

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

What is a covering index?

What is difference between sql and sql server?

Explain what is the difference between union and union all?

what is the Ticketing tool used in Wipro technologies at Bangalore...???

For more SQL Server Interview Questions Click Here