Can Having clause be used without Group by clause?
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
How does clustered and non clustered index work?
What is database isolation in sql server? : sql server database administration
How to send a ssrs report from ssis?
Can a rule be bound to any column of any data type?
What is the purpose of the tempdb database?
How to create function without parameter in sql server?
What is the report builder?
Do you know spatial data types - geometry and geography in sql server 2008?
What is an sql server agent?
What are user defined functions in ms sql server?
What is a dbms wizard?
Do you know the cursor optimization tips?
What is a mutating table error and how can you get around it?
Distinguish between nested subquery and correlated subquery?
OPTIMIZATION OF SP,CURSOR,TRIGGERS