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
- 26433 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 cursor stability in db2?
What do you mean by rollback?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is the difference between plan and package in db2?
How can you do the explain of a dynamic sql statement?
Are views updateable?
How do I import a csv file into db2?
What is the purpose of rollback and commit?
Explain db2.
How can you count the number of rows from a table tab?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is iseries database?
Which component is used to execute the sql statements?
How can you find out the # of rows updated after an update statement?
Which command is used to remove all rows from a table?
