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

I want to fetch the 10th row of a table which has been
changed.How can I do it without going thru all the rows.

Answer Posted / m4io

DECLARE cursor_name sensitivity SCROLL CURSOR FOR
SELECT ... FROM ...

FETCH ABSOLUTE 10 FROM cursor_name

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are bind parameters in db2?

1096


What is dbrm? What it contains? When it will be created?

1101


How many databases are there?

1107


What is null value in db2?

1075


What is dbrm library?

1114


What is plan in cobol db2?

1202


What is iseries database?

1114


What is the maximum length of sqlca?

1610


What are the benefits of using the db2 database?

1288


What is a storage group (stogroup)?

1284


What are the full forms of spufi and dclgen and why are they used?

1136


What are the bind parameters ibm db2?

1099


What is query_cache_limit?

1034


What does a deadlock mean in DB2?

1217


What is the latest version of ibm db2?

1335