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 where clause and having clause

Answer Posted / selvam a

HAVING clause can only compare a built in function but WHERE
clause can compare column name.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you count the number of rows from a table tab?

1093


How to check last update on table in db2?

1060


What db2 400?

1195


How to retrieve rows from a db2 table in embedded sql?

1394


What is the latest version of ibm db2?

1269


What is db2 plan table?

1052


How to take backup of table in db2?

1079


How many databases are there?

1056


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2331


What is netezza database?

1031


What is dbrm? What it contains?

1163


What do you mean by rollback?

991


What is the maximum length of sqlca?

1529


How do I delete a table in db2?

1074


What is the syntax for FETCH in DB2 ?

1216