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
- 22535 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 image copy in db2?
what is a corelated subquerry?
What is the picture clause of null indicator variable?
i want to maintain uniqueness on pdf without make lf??????????
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is the maximum length of sqlca?
What is cobol db2?
How do I create a view in db2?
Are view updateable?
What is schema in db2?
Mention the various locks that are available in db2.
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
How to find schema of a table in db2?
What is nvl in db2?
What is sqlca’s maximum length?
