select min(sal) from (select sal from (select sal from emp order by sal

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / neha singh

Answer Posted / neha singh

select min(sal)
from
(select sal from
(select sal from emp
order by sal desc)
where rownum<=2)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how to fetch common records from two tables? : Sql dba

1105

How is debugging done?

919

What is exit statement?

957

Can procedure in package be overloaded?

1028

What is Materialized View? In What Scenario we Use Materialized View?

9397

Can you join a table to itself?

1030

What are different methods to trace the pl/sql code?

1047

What is latest version of sql?

982

What is pls integer?

983

What is the difference between drop and truncate commands?

997

What is difference between sql and oracle?

1046

What is difference between sql and excel?

1006

Do stored procedures prevent sql injection?

919

Is sql dba a good career? : SQL DBA

939

Explain constraints in sql?

981