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 it compulsory commitment control in journal?

2480

What is reorg?

1162

What is the maximum number of columns in a db2 table?

1285

What is runstats db2?

1038

What is dbrm? When it will be created?

1029

If I have a view which is a join of two or more tables, can this view be updateable?

1139

What is a storage group (stogroup)?

1247

What is the physical storage length of the data types date, time, and timestamp?

1091

Why do we use cursor?

1105

When reorg is used?

1130

What is declare cursor?

1125

What are bind parameters in db2?

1048

What do you mean by rollback?

991

What is isolation level in db2?

1007

How can deadlocks be resolved?

938