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
- 27760 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 does a deadlock mean in DB2?
What is iseries database?
How to resolve deadlock issue
What is the advantage in De-normalizing tables in DB2?
Explain about rct in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
What is access path in db2?
How many databases are there?
What are the two types of logging in the db2 database? Explain them.
How is a typical db2 batch pgm executed?
What is release/acquire in bind?
Where do you specify them?
How does a cursor work?
What are db2 objects?
How to find primary key of a table in db2?
