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

Write SQL queries on Self Join and Inner Join.

620


What is the server name for sql management studio?

479


Can we perform backup restore operation on tempdb? : sql server database administration

590


What is the difference between a check constraint and a rule?

626


What are the different kinds of ssrs reports?

170






What is instead of trigger sql server?

504


What is the difference between dropping a database and taking a database offline?

701


How to create new databases with "create database" statements?

570


How to delete duplicate records based on single column from a table?

606


What are scalar functions in sql?

613


How to insert data into an existing table?

571


How to update multiple rows with one update statement in ms sql server?

639


What are the source of constraints?

512


What are the basic functions for master, msdb, model, tempdb and resource databases?

557


How to execute the cursor queries with "open" statements?

616