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
- 27764 Views
- KNIT, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / vijay reddy
select * from (select * from emp ) where rownum>=1 and rownum<5
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What do you mean by commit and rollback?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What are bind parameters in db2?
Define check constraint.
What are the 2 sqlcodes that are returned?
What's The Error Code For Unique Index Voilation?
What is the difference between dbm cfg and db cfg file in db2 ?
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.
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is drop table?
How can record locking be achieved in those DB2 versions which do not support it?
is it compulsory commitment control in journal?
Explain the contention situations caused by locks?
How do I start db2 in windows?
What is the role of the data page in the db2 database?
