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
What is the benefit of normalization?
Which tools are available to manage SQL Azure databases and servers?
How to create a trigger for insert only?
What is service broker?
How do database indexes work?
what types of replication are supported in sql server? : Sql server database administration
Explain foreign key in sql server?
What are the advantages of having an index on the sql server?
Can you name some of the dml commands in sql?
What is BCNF? How is it better than 2NF & 3NF?
What is the importance of a recovery model?
Does sql server use t sql?
Can group by be used without aggregate functions?
How do I start sql server 2016?
Explain trigger and its types?