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

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

I have a table which has thousand of records i want to
fetch only record num 100 to record num 200. Write a query
that satisfies this criteria.(Cant use any keys)
Anyone please reply ASAP!

Question Posted / mysterious

Answer Posted / mysterious

is it row number that u are looking for?

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is db2 a mainframe?

1096

What is the difference between dbm cfg and db cfg file in db2 ?

1591

What is a storage group (stogroup)?

1286

How to find the number of rows in a db2 table?

1154

What is host variable in db2 cobol?

1136

How do you select a row using indexes in db2?

1178

Differentiate between cs and rr isolation levels? Where do you specify them?

1119

What is the maximum No of rows per page?

1116

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1290

What does runstats do in db2?

1185

what is diffrence b/w file-aid tool and file-aid utility???

4959

Explain various types of locks in db2?

1207

What is ibm db2 connect?

1056

What is db2 bind?

1131

What is runstats utility in db2?

1070