Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Can Having clause be used without Group by clause?

Question Posted / sumathy

Answer Posted / sumathy

HAVING Clause
Specifies a search condition for a group or an aggregate.
HAVING is usually used with the GROUP BY clause. When GROUP
BY is not used, HAVING behaves like a WHERE clause.

Reference:
http://msdn.microsoft.com/en-us/library/aa259187
(SQL.80).aspx

Is This Answer Correct ?    30 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does the on update no action do?

1079

Does server sql treat char as a variable-length or fixed-length column?

1091

How raid can influence database performance?

1087

Define compound operators?

968

What is set nocount on?

994

What is tempdb in sql server?

1029

How do I open port 1433?

988

What is BCP? When does it used in sql server 2012?

1108

What are the different types of backups that exist?

1223

Do you know what is openxml in sql server?

1113

What is Service Broker in sql server 2012?

1073

How to restore performance issues and how to check?

2053

Can we call future method from queueable?

1097

What are the restrictions while creating batches in sql server?

1116

How to insert stored procedure result into temporary table?

1066