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
- 26450 Views
- KNIT, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / saeed
db2 "SELECT EmpNo FROM (SELECT EmpNo, dense_rank() over
(order by EmpNo) RNo FROM office) xyz WHERE RNo >= 100 AND
RNo<=200 "
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to find the number of rows in a db2 table?
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 is db2 look?
Where can you declare a cursor in a cobol-db2 program?
Explain about open switch business continuity software?
What is difference between isnull and coalesce?
Mention the different locking levels that are available in db2.
What is check constraint in db2?
Explain packages.
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
define clustering index.
What is the reason behind not using select * in embedded sql programs?
How do I add a column in db2?
Which component is responsible for db2 startup and shutdown?
What are union and union all?
