having clause alwaye use with aggregate functions and where clause use fo

What is the difference between having and where clause?

Question Posted / kundan ravi

Answer Posted / kundan ravi

having clause alwaye use with aggregate functions and where
clause use for conditions but not with aggregate functions.

Is This Answer Correct ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What stored procedure can you use to display the current processes?

899

What is a transact-sql statement?

1068

what is a self join? : Sql server database administration

1048

What are the filtered indexes?

1041

What are drillthrough reports?

156

Name some of the open source software that you can use in alternative to SSR?

161

What is implicit cursors?

1090

Which sql server table is used to hold the stored procedure script?

952

How to loop through returning rows?

1039

What is difference between getdate and sysdatetime in sql server 2008?

1056

SQL Server Architecture ?

2463

How to send a ssrs report from ssis?

176

Can group by be used without aggregate functions?

926

What is the temp table?

929

What is the difference between index seek vs. Index scan?

1026