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
- 26671 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 role in db2?
What are the different types of base tables?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Explain about rct.
What is the picture clause of null indicator variable?
Mention the different locking levels that are available in db2.
Is db2 relational database?
Explain correlated sub-queries.
What is rebind in db2?
What is the difference between oracle and db2?
What are host variables in db2?
What is difference between rollback and commit?
How will you return the number of records in table?
What is meant by union and union all?
Which component is responsible for processing sql statements and selecting access paths?
