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 / guest

Having Clause is basically used only with the GROUP BY
function in a query. WHERE Clause is applied to each row
before they are part of the GROUP BY function in a query.

Is This Answer Correct ?    68 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When does a workload on SQL Azure get throttled?

129


How to manipulate data from one table to another table ?

956


How to execute stored procedure in select statement sql server?

1030


Can sub report data source be different from that of the parent report?

141


What stored by the msdb? : sql server database administration

986


What is SQL Azure Federations?

112


How to create a ddl trigger using "create trigger" statements?

1109


What are the different types of indexes?

1088


Why use sub query in sql server and list out types of sub queries?

976


System variable and temporary variables

2230


Difference between group by clause and having clause in SQL?

955


What are data regions?

133


Equi join and non equi join is possible with sql server?

996


What is replication with database mirroring? : sql server database administration

1050


how can you check the level of fragmentation on a table? : Sql server administration

951