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
- 24447 Views
- KNIT, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / mvramesh
How about combingin two queries with set operator EXCEPT,
if you have query A EXCEPT query B, the result would be A-B.
Select * from table A fetch first 200 rows only
Union except
Select * from table A fetch first 100 rows only
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Comment whether the cursor is closed during commit or not.
How does cobol compile db2 program?
What is a db2 table?
Explain the benefits you can get from mainframe connect?
What is precompiler in db2?
What is lock escalation in db2?
What is isolation level in db2?
Explain correlated sub-queries.
What is ibm db2 used for?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Which isolation level provides highest data integrity?
What is the use of dclgen in db2?
What is the maximum length of sqlca?
What is the use of value function?
What is dclgen (declaration generator)?
