SQL> select max(sal) sal 2 from (select sal, 3

find out the second highest salary?

Question Posted / peter

Answer Posted / peter

SQL> select max(sal) sal
2 from (select sal,
3 dense_rank() over
4 (order by sal desc) rnk
5 from emp )
6 where rnk = 2;

SAL
----------
3000

SQL>

Is This Answer Correct ?

14 Yes

9 No

Please Help Members By Posting Answers For Below Questions

How to insert a record into a table?

1041

How to define a cusotmer as a supplier in ORACLE R12

2200

Why do we need oracle client?

913

Explain what are the characteristics of data files?

1051

What is oracle thin client?

990

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2098

Does oracle charge for java?

1030

How do I uninstall oracle client from windows?

985

What are the components of logical database structure in oracle database?

1057

What is instant client oracle?

993

How to use values from other tables in update statements using oracle?

1046

Is there a combination of "like" and "in" in sql?

1030

what is the use of system.effective.date variable in oracle?

1076

What are the database administrators utilities available?

994

How to install oracle odbc drivers?

1058