how to find the second highest salary in a given table????

Question Posted / ramakrishna_33

Answers were Sorted based on User's Feedback

how to find the second highest salary in a given table????..

Answer / kedar

select max(salary) from employees where salary < (select
max(salary) from employees);

the max salary is 24000
& second max is 17000
chwck out

Is This Answer Correct ?

8 Yes

0 No

how to find the second highest salary in a given table????..

Answer / shahnaz

To find the 2nd highest salary from emp table:

select max(sal) from emp where sal not in (select max(sal)
from emp )

Is This Answer Correct ?

3 Yes

2 No

how to find the second highest salary in a given table????..

Answer / manikandan. s

This is the nth max

SELECT salary
FROM (SELECT ROWNUM sl, salary
FROM (SELECT salary
FROM employees
GROUP BY salary
ORDER BY salary))
WHERE sl = n

Is This Answer Correct ?

1 Yes

1 No

how to find the second highest salary in a given table????..

Answer / mahesh

SELECT *
FROM (SELECT ROWNUM sl, salary
FROM (SELECT DISTINCT salary
FROM employees
ORDER BY salary))
WHERE sl = n

Is This Answer Correct ?

0 Yes

0 No

how to find the second highest salary in a given table????..

SELECT MAX( Sal ), LEVEL
FROM Emp
WHERE LEVEl = &Givelevelno
CONNECT BY PRIOR Sal > Sal
GROUP BY LEVEL;

Is This Answer Correct ?

0 Yes

0 No