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.
- 5 Answers
- 10927 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / divya,roshini,tiny
use scrollable cursor for fetching the 10th row
| Is This Answer Correct ? | 4 Yes | 0 No |
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 |
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 |
Answer / satish.klnm
exec sql
select * from table222 where count(*) > 9
end-exec.
| Is This Answer Correct ? | 0 Yes | 14 No |
what is Static and dynamic linking
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
How to define the data items to receive the fetch items for the SQL?
What is a view? Why use it?
What is Reorg Recovery? when will you run it?
How and when does the db2 enforces the unique key?
i want to maintain uniqueness on pdf without make lf??????????
Give the COBOL definition of a VARCHAR field.
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
What will the FREE command do to a plan?
What is the information associated with sysibm.syslinks table?
COBOL 
