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
- 26452 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 are catalog tables in db2?
Mention some fields that are a part of sqlca.
What is db2 optimizer?
What are the full forms of spufi and dclgen and why are they used?
What is the role of union all and union
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
How is a typical db2 batch pgm executed?
What is database manager in db2?
On which levels locks can be applied?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
How to get the ddl of a table in db2?
When do you specify the isolation level?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is runstats and reorg in db2?
What is the picture clause of null indicator variable?
