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

in my server i have 3 instances,one of them got failed, and this cause we r not able to connect to server, how to know which instance was dameged?

How do triggers work?

Can sql servers linked to other servers like oracle?

What are the types of sql server?

Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

Which command executes the contents of a specified file?

WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

How to store and query spatial data?

What is difference between cte and view?

What are the lambda triggers?

Do you know what is sql service broker?

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

For more SQL Server Interview Questions Click Here