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
- 27020 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
Explain package in db2 and its advantages?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is dbrm? What it contains?
What is load replace in db2?
what is db2 restart?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
How do I connect my db2 database to ibm?
What is the syntax for creating a table in the db2 database?
What does runstats do in db2?
Highlight all the advantages that are attached to a package.
Discuss about db2 bind?
What r the comman abends in db2, jcl and cobol???????
can we view the access paths created by dbrm ? how ? thx
What is concurrency?
How to check last update on table in db2?
