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
- 27714 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 do you mean by between and in? Is between inclusive of specified range values?
What is dbrm? What it contains?
How can you do the explain of a dynamic sql statement?
What is host variable in db2 cobol?
What is the difference between drop table and delete table?
What is difference between alias and synonym in db2?
What is the difference between nvl and coalesce?
How to fetch the last row from the table in SQL (db2)?
What is db2 purescale?
What is the role of schema in the db2 database?
How would the varchar column remarks defined?
Why do we need reorg in db2?
Explain about rct.
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
Outputs of explain are with matchcols = 0. What does this signify?
