HAVING Clause Specifies a search condition for a group or an aggregate.

Can Having clause be used without Group by clause?

Question Posted / sumathy

6 Answers
43350 Views
CarrizalSoft Technologies, CSC, CTS, I also Faced
E-Mail Answers

Answer Posted / sumathy

HAVING Clause
Specifies a search condition for a group or an aggregate.
HAVING is usually used with the GROUP BY clause. When GROUP
BY is not used, HAVING behaves like a WHERE clause.

Reference:
http://msdn.microsoft.com/en-us/library/aa259187
(SQL.80).aspx

Is This Answer Correct ?

30 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is nonclustered index on computed columns?

962

Can we deploy SSRS reports on our personal website?

168

What is the difference between set and select?

1099

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2489

What are the different types of indexes?

1120

What is the user of Primary key?

990

What is index fragmentation in ms sql server?

1092

What is a user-defined function in the sql server and what is its advantage?

1108

Explain iaas, paas and saas?

Explain the difference between delete,drop and truncate in SQL Server?

1103

What is ms sql server index?

1109

What is the difference between local and global temporary tables?

1140

What causes index fragmentation?

999

What are the grouping functions?

939

What are the different types of backups that exist?

1176