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
- 22480 Views
- KNIT, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / mysterious
is it row number that u are looking for?
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is check constraint in db2?
Why do chiropractors use drop table?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is meant by explain?
What is collection in db2 bind?
Explain the contention situations caused by locks?
What is difference between isnull and coalesce?
Is ibm db2 free?
Explain the contents that are a part of dclgen.
What is phantom read in db2?
What are the uses of db2 optimizer?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
List down the data types in the db2 database.
