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
- 24483 Views
- KNIT, Tech Mahindra, I also Faced
- E-Mail Answers
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
Is db2 a programming language?
Is ibm db2 open source?
What is bind plan?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What are the various isolation levels possible?
What are concurrency issues?
What is isolation level in db2?
Define predicate?
How is the value function used?
Is db2 a database?
What does runstats do in db2?
can we view the access paths created by dbrm ? how ? thx
What do you mean by between and in? Is between inclusive of specified range values?
How to rename a table in DB2 ?
What is rebind in db2?
