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

What is database alias db2?

1076

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

1234

What is query_cache_limit?

937

What are the 2 sqlcodes that are returned?

1143

What is the use of dclgen in db2?

1026

What is the difference between bind and rebind in db2?

1413

What are the contents of dclgen?

1069

What is the use of predicate?

1001

How do I add a column in db2?

1011

What is lock escalation in db2?

978

Mention the location where the output received from explain statement is stored.

1080

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2351

What is with ur in db2?

1261

What is a cursor in programming?

1028

What are bind parameters in db2?

995