Can Having clause be used without Group by clause?

Answer Posted / debasish

we can use having clause without group bu clause .but it
will act as where clause

Is This Answer Correct ?    68 Yes 33 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What happens if null values are involved in boolean operations?

736


What is an etl file?

699


What is data mart? : sql server analysis services, ssas

804


How does the report manager work in SSRS?

131


What is t-sql script to take database offline – take database online.

790






What is nolock hint in sql server 2008

824


How you can find out if an index is useful to the optimizer?

660


How to create function without parameter in sql server?

738


What is the optimization being performed in oracle and SQL Server?

796


what are the disadvantages of cursors? : Sql server database administration

683


What is ssl in sql server?

747


What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

889


How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

792


Sql server reporting services vs. Crystal reports.

112


What is change data capture (cdc) in sql server 2008?

754