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!
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
How to access db2 tables in mainframe?
Is db2 free?
What is package in db2 mainframe?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is the use of value function?
Is db2 a programming language?
Name the lockable units in DB2?
How to run db2 command in windows?
What is explain plan in db2?
What parameters are used to control the free space in DB2?
Which isolation level provides highest data integrity?
What is the maximum number of columns in a db2 table?
What db2 400?
What do you mean by rollback?
What is the latest version of ibm db2?