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 / andyb

Why?
How do you know the one you want is still the 10th row ?
Other updates may have taken place.

If you know the key for the record you want then use that

Otherrwise unless the table has a sequential numeric key
then I think you have to go through the rows.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a dbrm in db2?

982


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1356


What is the difference between nvl and coalesce?

1027


What is a db2 package?

1011


What is copy pending and check pending in db2?

972


How to get the ddl of a table in db2?

1102


What is the result of open cursor statement?

1049


What is performance tuning db2?

1025


define clustering index.

995


How do I import a csv file into db2?

950


What is the difference between db2 and oracle?

1087


When do you specify the isolation level?

995


Explain packages.

1071


List out the buffer pools in db2

1043


What are the contents of a dclmgen?

1090