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

What is meant by temporal data?

1002

What is rename in sql?

1017

Explain table and field in sql?

1117

What is replication id?

987

Can sql developer connect to db2?

1104

Why procedure is used in sql?

1087

What is a data definition language?

1195

What is left join in postgresql?

1092

What is the difference between cross join and natural join?

1066

What is foreign key and example?

982

Which tcp/ip port does sql server run?

1068

What is data control language?

1032

What are the types pl/sql code blocks?

1195

State some properties of relational databases?

1115

What is pragma in sql?

1127