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!
- 17 Answers
- 24434 Views
- KNIT, Tech Mahindra, I also Faced
- E-Mail Answers
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
What is copy pending status in db2?
What is null value in db2?
i want to maintain uniqueness on pdf without make lf??????????
Explain about rct in db2?
What is the purpose of rollback and commit?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is the physical storage length of the data types date, time, and timestamp?
How to find schema of a table in db2?
What is deadlock in db2?
What is buffer pool?
What is db2 plan table?
What is cursor in dbms?
What is cursor with hold option in db2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is the use of runstats in db2?
