Use any one column name and its value of the 10th row to fetch the 10th..

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.

Question Posted / nadeem

5 Answers
10514 Views
I also Faced
E-Mail Answers

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

Define sqlca.

1052

How can record locking be achieved in those DB2 versions which do not support it?

1015

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

1306

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

968

What is the maximum No of rows per page?

1010

What is lock escalation in db2?

963

can we view the access paths created by dbrm ? how ? thx

6969

What is access path in db2?

923

What is a system catalog table in db2?

1096

What is an instance database?

1002

What is a page in db2?

979

Name the lockable units in DB2?

1070

What is the difference between db2 and oracle?

1065

If I have a view which is a join of two or more tables, can this view be updateable?

1081

What are the 2 sqlcodes that are returned?

1128