Can Having clause be used without Group by clause?
- 6 Answers
- 41619 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
Is it true, that there is no difference between a rule and a check constraint?
How to create new table with "create table" statements?
What is rs.exe utility?
How do I find information about the install locations for the various instances running on a computer?
Explain multiserver query
Why SQL Agent is used?
Tell me what is difference between view and materialized view?
List all the types of user-defined functions?
What is RAID? What are the different types of RAID configurations?
What are the new data types are introduced in sql 2000?
What is bcnf normalization form?
What is sql server programming?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
How to sort the query output with order by clauses in ms sql server?
What is compound operators?
