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...

how to fetch first 100 rows in db2

Answer Posted / jagan

select top 100 from tableName;

Is This Answer Correct ?    1 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to fetch the last row from the table in SQL (db2)?

1653


Why do we bind in db2?

1210


Is ibm db2 open source?

1075


Why db2 is called db2?

1038


Explain how can you do the explain of a dynamic sql statement?

1125


What is database alias db2?

1125


What are the prerogatives?

1080


Explain various types of locks in db2?

1150


What is a bind in db2?

1042


How is a typical db2 batch pgm executed?

1174


What is a plan and package in db2?

1102


What do you mean by cursor?

988


Which isolation level provides maximum concurrency?

1152


How to execute stored procedures?

1130


What is an instance in db2?

1033