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
- 22475 Views
- KNIT, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / the boss
There is no correct answer to this flawed question.
In RDBMS theory a table doesn't have 'records'; it is an
UNORDERED set of tuples ("rows"), so there is no
recordnumber 100 or 200.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between nvl and coalesce?
Where can you declare a cursor in a cobol-db2 program?
What is host variable in db2 cobol?
Give a brief description of db2 isolation levels?
What are foreign keys in db2?
What is sqlca?
What do you mean by between and in? Is between inclusive of specified range values?
What is the usage of open cursor command?
What is db2 optimizer?
Are view updateable?
How does cobol compile db2 program?
What is the physical storage length of time data type?
Define db2 and its databases?
How do I change the column size in db2?
How is deadlock resolved?
