Interested to Buy Any Domain ? << Click Here >> for more details...
Can Having clause be used without Group by clause?
- 6 Answers
- 42914 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
Define Unique Key?
What is hot add cpu in sql server 2008?
What is implicit mode in sql server?
Define Business Edition in SQL Azure?
what is database replication? : Sql server database administration
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What is temporal table?
How to delete duplicate rows from table except one?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
What are the advantages of policy management?
What is bookmark link in ssrs?
How to delete exactly duplicate records from a table?
What is a non-clustered index?
