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 is difference between rollback and commit?

1154


What is a Foreign Key?

1095


What is a storage group (stogroup)?

1241


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1055


B37 abend during spufi?

1453


What are the rules for db2 programming?

1082


Explain the benefits you can get from mainframe connect?

970


How to view db2 table structure?

1015


Is db2 relational database?

972


What language is db2 written in?

1042


What is the role of data manager in the db2 database?

1102


How can you classify the locks in db2?

1088


What is a db2 package?

1049


Before you give the explain statement, what are the prerogatives?

1028


Explain in brief how does db2 determine what lock-size to use?

1037