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

Answer Posted / narender sharma

Where clause is used to restrict rows but having clause is
used to restrict groups

Is This Answer Correct ?    28 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2304


What is oracle and what are its different editions?

1080


How to rename a tablespace in oracle?

1093


What is the difference between truncate & delete command?

1193


What is null value in oracle?

1103


How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2189


How to create a temporary table in oracle?

1280


How to invoke the original export import utilities?

1073


There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2038


What is the difference between "as" and "is" in an oracle stored procedure?

1005


What is a read only transaction in oracle?

1035


How to Truncate Table in Oracle

1166


What is key preserved table?

1028


defination of bitmap index

2135


What is materialized view in Oracle?

1079