Answer Posted / nishi
select rownum, empno, ename from emp where rowid in (select rowid from emp where rownum <=&upto minus select rowid from emp where rownum<&Start);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to rename an existing table?
What is the usage of control file in oracle?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
What is where clause in oracle?
Explain a data segment?
what's query optimization and without use of IN AND Exist can we get another way data from query
What is an Oracle index?
Design database draw er diagram for a certain scenario ?
What is recycle bin in Oracle?
What are the different types of record groups in oracle? Explain each of them
what is the use of system.effective.date variable in oracle?
How to display employee records who gets more salary than the average salary in the department?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What exactly do quotation marks around the table name do?
Describe the types of sub query?
