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

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

590


What stored procedure can you use to display the current processes?

496


Explain iaas, paas and saas?

74


What is a transaction and why is it important?

573


What is named calculation? : sql server analysis services, ssas

531






What is master database? : SQL Server Architecture

535


How can we delete Duplicate row in table?

636


What is side by side migration in sql server?

538


Why use sub query in sql server and list out types of sub queries?

543


What is transaction server explicit transaction?

545


What are tables in sql server?

534


Explain a checkpoint?

538


What is a unique key constraint?

533


What is sql sandbox in sql server?

621


What are page splits?

581