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

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2087


Is ibm db2 free?

1003


What is ibm db2 connect?

985


What is load utility in db2?

1179


What are host variables in db2?

1065


What is db2 command?

1029


How do you stop a db2 database in linux?

1008


How can you find out the # of rows updated after an update statement?

1108


How to create backup table in db2?

1088


what is a corelated subquerry?

1120


How to compare data between two tables in db2?

1082


Is db2 free?

1090


What is explain plan in db2?

982


How would the varchar column remarks defined?

1086


define clustering index.

1019