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 a HAVING CLAUSE and a WHERE
CLAUSE?

Answer Posted / manisha

Having clause is used to filter group while WHERE CLAUSE
is used to filter rows.
Having clause can have aggregate function but WHERE CLAUSE
cannot have aggregate function.

Is This Answer Correct ?    22 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List down some advantages of sql stored procedure?

1015


Which sql server table is used to hold the stored procedure scripts?

1110


Explain what is raid and what are different types of raid levels?

1088


What is use of @@ spid in sql server?

1272


How raid can influence database performance?

1085


Explain “@@rowcount” and “@@error” in sql server?

1132


What is shrink log file?

952


Mention what are the core components of ssrs?

330


How to convert numeric expression data types using the cast() function?

1120


How to find Duplicate Records In table?

1071


How can you find out which stored procedures are recompiling?

950


What is the difference between getdate and sysdatetime?

1061


How to view the error log for any specific instance? : sql server database administration

1098


What is entity data services?

1115


Mention the uses of stored procedures.

1006