SELECT MIN(SAL) FROM(SELECT distinct SAL FROM EMP ORDER BY SAL DES

how to find the second highest salary from emp table?

Question Posted / sreekanth

Answer Posted / sreekanth

SELECT MIN(SAL)
FROM(SELECT distinct SAL FROM EMP
ORDER BY SAL DESC)
WHERE ROWNUM <= :N
where N is the Nth highest salary u want

Is This Answer Correct ?

18 Yes

22 No

Please Help Members By Posting Answers For Below Questions

What are inbuilt functions in sql?

1107

What is coalesce in sql?

1130

What is autocommit sql?

1042

how to rename an existing table in mysql? : Sql dba

1114

How delete all data from all tables in sql?

985

Does execute immediate commit?

1289

how to select first 5 records from a table? : Sql dba

1024

How can use stored procedures in sql?

1190

What are predefined functions in sql?

1105

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

1017

what are integrity rules?

1092

What is the difference between inner join and left join?

1036

What is %rowtype in pl sql?

1030

What is sorting in sql?

983

what is a control file ? : Sql dba

1089