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

How many partitions a clustered index has by default in sql server 2012?

752


Explain foreign key in sql server?

657


Can primary key be null?

603


Explain query editor regions

718


What are the differences between user defined functions and stored procedures?

622






Explain how many normalization forms?

658


What is wrong with sql server client libarary dll, ntwdblib.dll?

664


What is awe?

673


SQL Server Architecture ?

2017


Explain what are commit and rollback in sql?

607


What is a field in a table?

674


How do I open port 1433?

617


What is normalization of database? What are its benefits?

592


Explain the dirty pages?

664


Name 3 ways to get an accurate count of the number of records in a table?

676