select min(empsal) from (select * from sal order by empsal desc) where

how to find the second highest salary from emp table?

Question Posted / abir dutta

Answer Posted / abir dutta

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the different datatypes available in PL/SQL?

1083

Can one improve the performance of sql*loader? : aql loader

1046

What is the difference between inner join and left join?

985

What is a relationship and what are they?

1146

What is example of database?

1052

What does count (*) mean?

927

State some properties of relational databases?

1056

What is the difference between inner join and outer join?

992

Which is better cte or subquery?

1026

What sql does db2 use?

978

how to add a new column to an existing table in mysql? : Sql dba

1066

What does (*) mean in sql?

948

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

1024

What is a sql driver?

995

What information is needed to connect sql*plus an oracle server?

1026