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

Why cross join is used?

1084

What is execute immediate?

1089

What is sqlerrm?

943

Can we commit in trigger?

983

describe mysql connection using mysql binary. : Sql dba

1072

What are secondary keys?

976

How do we accept inputs from user during runtime?

1072

I need a function for a train ticket reservation please answer it thanks in advance

1033

What is fmtonly in sql?

1090

What are the basic techniques of indexing?

1070

What is %rowtype in pl sql?

995

how to run 'mysql' commands from a batch file? : Sql dba

1124

What is delete command in sql?

1121

how many ways to get the current time? : Sql dba

1012

What is a stored procedure in sql with example?

1138