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...

what is the difference between group and having
give an example with query and sample output

Answer Posted / pawan378

in addition to the above correct answers ..

Having Clause allows to add conditions using functions

Ex: COUNT(*) > 2

at on the same phrase of the query. this will be basically
to avoid sub queries.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you create an execution plan?

885


What is instead of dml trigger?

951


What is the use of keyword with encryption.

970


Difference between Inner vs outer joins?

894


How to concatenate two strings in SQL Server.

1080


Explain what are the different index configurations a table can have?

1037


Which language rdl files made of?

124


what are constraints? Explain different types of constraints? : Sql server database administration

918


What is the stored procedure?

948


Do you know what is a trace frag? Where do we use it?

955


Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

895


How to list all objects in a given schema?

985


What is the recovery model?

931


What are distributed partitioned views?

1006


Difference between Logical Page and Physical Page in SSRS.

459