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
- 27760 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 query_cache_limit?
What is rebind in db2?
On which levels locks can be applied?
What is a db2 collection?
Where can you declare a cursor in a cobol-db2 program?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
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?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
How can you count the number of rows from a table tab?
What does sqlcabc has?
How is a typical db2 batch pgm executed?
What is db2 command?
what is utility for parm lib
What is role in db2?
How many databases can be created inside an instance in db2 ?
