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

What is a full join sql?

1061

What does select * from mean in sql?

3248

What does (+) mean in sql joins?

1071

Can unique keys be null?

917

How do I count records in sql?

1016

What is the use of sqlerrd 3?

945

What is partition in sql query?

1004

What is the difference between clustered and non-clustered indexes?

1093

What is the use of procedures?

976

What is procedure explain with program?

1025

What are secondary keys?

976

what is sql? : Sql dba

1030

What are conditional predicates?

1064

What is rownum?

987

What is graph sql?

996