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
- 27766 Views
- KNIT, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / om yadav
mr. Prasenjit ..
when you are going to select 100 record then you select
which column base you want the record taht base you mession
on condition.
than
if any other way please tell me.........
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is dclgen (declaration generator)?
Give a brief description of db2 isolation levels?
Explain the function of data manager.
Which component is responsible for db2 startup and shutdown?
What is the syntax for FETCH in DB2 ?
What is a db2 schema?
How can you quickly find out the # of rows updated after an update statement?
What is difference between isnull and coalesce?
Is db2 a mainframe 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
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is a system catalog table in db2?
What is dpf in db2?
How does a cursor work?
Why cursor is used in db2?
