Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 27744 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
How do I connect my db2 database to ibm?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
How to test SQL -911 error while developing COB-DB2 program
What is scrollable cursor in db2?
What is difference between isnull and coalesce?
What is db2 look?
Comment whether the cursor is closed during commit or not.
What is a db2 table?
How many databases can be created inside an instance in db2 ?
How do we specify index to include or not during bind process.
What is ibm db2 connect?
What is the latest version of ibm db2?
Which component is responsible for processing sql statements and selecting access paths?
Is db2 a mainframe?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
