Can Having clause be used without Group by clause?
- 6 Answers
- 40162 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
how we use window authentication connection with sql server.?
How to rebuild all indexes on a single table?
What is 5nf in normalization form?
what are isolation levels? : Sql server database administration
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
If a table does not have a unique index, can a cursor be opened on it?
Tell me what is log shipping?
Explain full-text query in sql server?
Define right outer join?
What is proper subset of candidate key?
Comment,Datatypes are unlimited
Define Business Edition in SQL Azure?
What are entities and relationships?
What do you understand by intent locks?
What is report snapshot?
