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
- 22519 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 bufferpool in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How do I start db2 in windows?
How do I connect my db2 database to ibm?
What are db2 objects?
What is ibm db2 client?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is the reason behind not using select * in embedded sql programs?
What is a bind card?
What is the use of value function?
What is runstats utility in db2?
Which is faster delete or truncate?
What is a db2 schema?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is the use of reorg in db2?
