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
- 27225 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
How do I copy a table in db2?
Mention some fields that are a part of sqlca.
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is a bind in db2?
What is db2 and what is the use of db2 optimizer?
What is runstats and reorg in db2?
How does cobol compile db2 program?
What is runstats utility in db2?
Explain correlated sub-queries.
What is reorg?
What is coalesce in db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
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 component is responsible for processing sql statements and selecting access paths?
What is performance tuning db2?
