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 runstats db2?

576


What are db2 tables?

641


What is plan in cobol db2?

585


How do we specify index to include or not during bind process.

1674


What is a db2 tablespace?

595






How can we read records for specific member in CL? AND rpg?

228


Define buffer pool.

619


Which command is used to connect to a database in DB2 ? Give the Syntax.

596


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

2683


How many databases can be created inside an instance in db2 ?

591


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

637


What does db2 blu stand for?

658


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

712


What is alias in db2?

563


What are the benefits of using the db2 database?

658