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!
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 do you mean by cursor?
How do I start db2 in windows?
Outputs of explain are with matchcols = 0. What does this signify?
List down the data types in the db2 database.
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Explain the benefits you can get from mainframe connect?
What are db2 tables?
What do you mean by storage group (stogroup)?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is the difference between oracle and db2?
Define buffer pool.
what is a corelated subquerry?
What is a db2 schema?
What is collection in db2 bind?
What is isolation level in db2?