Answer Posted / gyana ranjan behera
sql>select ename,sal from(select ename,sal,rownum rn from
(select ename,sal from emp order by sal desc)
where rn=2;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is java oracle used for?
How to create an oracle testing table?
How does Oracle guarantee data integrity of data changes?
What is ADDM Advisor in Oracle?
What is control file used for?
what is Single Byte Overhead...?
How to write numeric literals in oracle?
How to connect to oracle using service name instead of sid?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
Why cursor variables are easier to use than cursors?
What are the differences between lov and list item?
types of indexes and the rationale behind choosing a particular index for a situation.
What is the difference between translate and replace in oracle?
How do I manually uninstall oracle client?
Is oracle the best database?