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 does dml mean?

993

Which type of cursor is used to execute the dml statement?

961

Which tcp/ip port does sql server run?

1014

how to delete an existing column in a table? : Sql dba

1009

what happens if you no create privilege in a database? : Sql dba

1006

discuss about myisam index statistics collection. : Sql dba

954

Write a query to find the names of users that begin with "um" in sql?

1002

What is rename in sql?

979

how do you know if your mysql server is alive? : Sql dba

1081

Does oracle roll back the transaction on an error?

1022

what is a stored procedure? : Sql dba

1140

What are the different ways to optimize a sql query?

950

What is difference between stored function and application function?

1208

how can we destroy the session, how can we unset the variable of a session? : Sql dba

1005

How do you change a value in sql?

1023