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
- 27221 Views
- KNIT, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / prasenjit
Yes and no in both ways.
I know there is a Roid() Over() function DB2 release 7
onwards and that shld solve the problem.
But what if there was condition that you cant use these
functions.
Cant there be any query that can produce the req result.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What kind of database is db2?
Which is faster delete or truncate?
What is the usage of open cursor command?
How to find primary key of a table in db2?
List some fields from sqlca?
Who uses db2?
What is a db2 collection?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is the difference between spufi and qmf?
Describe major components of db2?
Why do we bind in db2?
What is database reorganization?
What are the different types of base tables?
List out the data types available.
What is buffer pool in the db2 database?
