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 the difference between online and offline backups?
How to convert numbers to characters in oracle?
What do you mean by a deadlock?
How do I limit the number of rows returned by an oracle query after ordering?
Explain the importance of .pll extension in oracle?
What privilege is needed for a user to insert rows to tables in another schema?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
What is memory advisor in Oracle?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Explain the features of oracle?
How to run queries on external tables?
How many categories of data types?
What is oracle latest version?
how the indexes are stored in the Oracle Database?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.