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
- 22486 Views
- KNIT, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / vikatakavi08
select * from emp where rownum<=100 and rownum>=200;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is an instance in db2?
What is rct?
How can we retrieve the total number of records in RPG & CLLE?
What is the physical storage length of time data type?
What is performance tuning db2?
What is database reorganization?
How to check last update on table in db2?
Mention the location where the output received from explain statement is stored.
What is a bind card?
What is table space in db2?
what is db2 restart?
What do you mean by commit and rollback?
Who uses db2?
How to check table size in db2 sap?
What is db2 catalog database?
