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 / venkat
select * from table where empno > 100 or ( select * from
table where empno < 200)
Some many ways to write a query for this, this is one way...
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is runstats db2?
Mention the location where the output received from explain statement is stored.
What is the latest version of ibm db2?
What is difference between alias and synonym in db2?
Which are the db2 tools to protect integrity of the database?
What is the difference between nvl and coalesce?
What is a db2 table?
Explain what are the various isolation levels possible?
What is temporal table in db2?
How do I start db2 in windows?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
can we view the access paths created by dbrm ? how ? thx
What is the purpose of using commit?
How to find schema of a table in db2?
Explain in brief how does db2 determine what lock-size to use?