I have a table which has thousand of records i want to
fetch only record num 100 to record num 200. Write a query
that satisfies this criteria.(Cant use any keys)
Anyone please reply ASAP!
Answer Posted / rajeshkumar
SELECT * FROM TCB732D.AR_AR WHERE NUM_SEQ_AR IN(
SELECT NUM_SEQ_AR FROM TCB732D.AR_AR ORDER BY NUM_SEQ_AR
FETCH FIRST 200 ROWS ONLY)
ORDER BY NUM_SEQ_AR FETCH FIRST 100 ROWS ONLY
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Define check constraint.
Is db2 a mainframe?
What is db2 optimizer?
Outputs of explain are with matchcols = 0. What does this signify?
How can record locking be achieved in those DB2 versions which do not support it?
what is the sqlcode -501
What is ibm db2 connect?
How do I copy a table in db2?
What action db2 takes when a program aborts in the middle of a transaction?
What is innodb buffer pool?
How to find schema of a table in db2?
What is db2 bind?
Explain correlated sub-queries.
Explain the benefits you can get from mainframe connect?
How will you return the number of records in table?