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
Difference between hot backup vs. Cold backup?
What is oracle instant client?
What is a user role in oracle?
What is the usage of synonyms?
IS it possible to built the oracle database without setting the kernal parameters?
What is java oracle used for?
What are the predefined tablespaces in a database?
How to convert csv to table in oracle?
 What are the oracle DML commands possible through an update strategy?
How to use null as conditions in oracle?
What is a trace file and how is it created in oracle?
What is the difference between substr and instr?
Point out the difference between user tables and data dictionary?
What is an oracle and why it is used?
Explain the use of constraints option in exp command.
