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
- 27224 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
If I have a view which is a join of two or more tables, can this view be updateable?
What is null value in db2?
Explain about open switch business continuity software?
what is the role of the cursor in db2?
What is the difference between nvl and coalesce?
What is runstats and reorg in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
What is cascading rollback?
What are host variables in db2?
How can you find out the # of rows updated after an update statement?
Explain in detail about buffer manager and its functionalities?
What is ibm db2 database?
How many databases can be created inside an instance in db2 ?
What is bind in db2?
What is the use of predicate?
