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
- 26706 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 the difference between plan and package in db2?
Which components manage deadlocks in db2?
What is the maximum No of rows per page?
How do I start db2 in windows?
Is db2 a mainframe?
What is a collection in db2?
Explain the function done by data manager?
What is the physical storage length of date data type?
Mention data types used in db2 ?
Which component is responsible for db2 startup and shutdown?
What is the syntax for seeing the columns and data types of a table in the db2 database?
How to create backup table in db2?
What is a db2 table?
What are bind parameters in db2?
What are union and union all?
