I want to fetch the 10th row of a table which has been changed.How can I do it

Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
Suggest New Category

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

5 Answers
10700 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I want to fetch the 10th row of a table which has been changed.How can I do it without going thru ..

Answer / m4io

DECLARE cursor_name sensitivity SCROLL CURSOR FOR
SELECT ... FROM ...

FETCH ABSOLUTE 10 FROM cursor_name

Is This Answer Correct ?

6 Yes

0 No

I want to fetch the 10th row of a table which has been changed.How can I do it without going thru ..

Answer / divya,roshini,tiny

use scrollable cursor for fetching the 10th row

Is This Answer Correct ?

4 Yes

0 No

I want to fetch the 10th row of a table which has been changed.How can I do it without going thru ..

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

I want to fetch the 10th row of a table which has been changed.How can I do it without going thru ..

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

I want to fetch the 10th row of a table which has been changed.How can I do it without going thru ..

Answer / satish.klnm

exec sql
select * from table222 where count(*) > 9
end-exec.

Is This Answer Correct ?

0 Yes

14 No

Post New Answer