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

Use any one column name and its value of the 10th row to
fetch the 10th..for eg
select * from Table where deptno = 0010(any column name and
its value of 10 row)

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is bufferpool in db2?

1049


How to resolve deadlock issue

20104


How to run db2 command in windows?

1191


What types of tables are there in the db2 database?

1051


What are the bind parameters ibm db2?

1046


What is cloudant database?

1094


Who uses db2?

1034


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

1084


What is a system catalog table in db2?

1184


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2088


What is bind and rebind in db2?

1133


What is clone table?

1036


What is the difference between cursor and select statement?

1096


Is db2 relational database?

971


What is schema in db2?

1018