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

how to create a new table in mysql? : Sql dba

1000

How do I run a sql trace?

967

What is normalisation in sql?

1073

what is an alias command? : Sql dba

1125

How subquery works in sql?

1079

Why left join is used in sql?

989

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

1038

What is difference between mysql and postgresql?

1168

What view means?

990

What are records give examples?

1018

What is sql constant?

1041

How do I run a pl sql procedure in sql developer?

982

Is sql scripting language?

1060

What is database sql?

1060

What is the difference between between and in condition operators?

1016