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
- 27730 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
What is a db2 package?
What is package in cobol db2?
What is access path in db2?
What is iseries database?
How does coalesce work?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
How to execute stored procedure in db2 command editor?
What is package in db2 mainframe?
What does db2 mean?
If I have a view which is a join of two or more tables, can this view be updateable?
List some fields from sqlca?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What does db2 stand for?
What parameters are used to control the free space in DB2?
What is a cursor in programming?
