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 HAVING clause and the WHERE
clause?

Answer Posted / senthil kumar t

Where clause is used for conditional retreiving from the
table and also aggregate functions can be used in where
clause. Having clause will be used for the recordset this
also supports the aggregate functions

Is This Answer Correct ?    10 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain some stored procedure creating best practices or guidelines?

936


Why de-normalization required?

1001


What is a dbms wizard?

1020


Describe in brief databases and sql server databases architecture.

1008


What is a trace frag?

1085


How do I create a stored procedure in sql server?

1034


Explain intellisense for query editing

1029


What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

902


How many types of functions are there in sql server?

946


What is check constraint in sql server?

1002


what exactly sql injuction.how to overcome.....

2542


How can you ensure that the database and sql server based application perform well?

1077


What command must you use to include the not null constraint after a table has already been created?

1145


How to enter date and time literals in ms sql server?

1016


what types of replication are supported in sql server? : Sql server database administration

1044