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
- 22485 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 does db2 plan contain?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is a db2 tablespace?
Is db2 a programming language?
What are the different types of base tables?
How do I create a view in db2?
How to find schema of a table in db2?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
List out the data types available.
What is table space in db2?
what is utility for parm lib
what is the role of the cursor in db2?
What is a db2 package?
What is a buffer in memory?
What are host variables in db2?
