SELECT MAX(sal) from emp a where &n=(select COUNT(DISTINCT (SAL)) from

how to find the second highest salary from emp table?

Question Posted / erp_guns

Answer Posted / erp_guns

SELECT MAX(sal) from emp a where &n=(select COUNT(DISTINCT
(SAL)) from emp b where a.sal<=b.sal)

Is This Answer Correct ?

39 Yes

22 No

Please Help Members By Posting Answers For Below Questions

How do you copy a table in sql?

1009

What is difference between joins and union?

1042

Is nosql relational?

891

What's the difference between inner join and left join?

946

Is pl sql and postgresql same?

1052

how do you tune the slow running queries in oracle db , explain the methodology

2048

What is equi join in sql?

1007

What are the advantages of pl sql?

1070

How exception handling is done in advance pl/sql?

917

What is the difference between subquery and correlated query?

986

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3515

how many sql ddl commands are supported by 'mysql'? : Sql dba

953

Are pl sql variables case sensitive?

996

How to add a column ‘salary’ to a table employee_details?

953

What are the indexing methods?

1001