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
- 27239 Views
- KNIT, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / sangeeta david
We can make use of Relative record number that is
Select * from Table A where RRN(A) between 100 and 200
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is the maximum length of sqlca?
Is db2 free?
What is the purpose of using commit?
Is db2 a database?
What is the physical storage length of time data type?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
When do you specify the isolation level?
Explain the contents that are a part of dclgen.
What is db2 bind process?
Describe major components of db2?
Can one database have multiple instances?
What is ibm db2 database?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is the difference between db2 and oracle?
What is the difference between using bind () and rebind () methods of naming class?
