1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Can we use having clause without group by?

Question Posted / harika


Can we use having clause without group by?..

Answer / Gaurav Upadhyaya

No, the HAVING clause is used in conjunction with the GROUP BY clause to filter groups and not individual rows. If you want to apply a condition on individual rows, it should be done using WHERE clause.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

1 Answers  

What does the update command do?

1 Answers  

A left outer join B B right outer join A gives the same result then what is the use of two?

1 Answers  

What are the different SQL Server Versions you have worked on?

0 Answers  

what is meant by deafult in sql server?

2 Answers  

What are the various editions of sql server 2017 that are available in the market?

1 Answers  

what is package and it uses and how can u call a package

1 Answers   Satyam,

What are the factors you will check for the performane optimization for a database query?

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,

Explain timestamp datatype?

1 Answers  

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1 Answers  

How do I find the sql server version?

0 Answers  

How to add more data to the testing table in ms sql server?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories