Can Having clause be used without Group by clause?

Answer Posted / anilreddy

No,we can not use.If there is Having it must followed by Group By

Is This Answer Correct ?    6 Yes 52 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you know concepts and capabilities of sql server?

584


How to insert data with null values?

586


How do I start sql server agent automatically?

504


Do you know what is difference between stored procedure and user defined function?

614


What is the difference between commit and rollback?

506






What are the differences between web role and worker role?

100


Explain what is row_number function?

563


What are the advantages dts has over bcp?

532


What is the difference between locking and multi-versioning?

538


Why use “in” clause in sql server?

556


What is the template in sql?

539


What is data source view or dsv? : sql server analysis services, ssas

555


Define tempdb database?

595


What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

117


Is mysql the same as sql server?

511