how to check the 3rd max salary from an employee table?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / smitha

23 Answers
37939 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to check the 3rd max salary from an employee table?..

Answer / somanath

select sal from emp a where 3=(select
count(distinct(sal)) from emp b
where a.sal<=b.sal)

Is This Answer Correct ?

34 Yes

7 No

how to check the 3rd max salary from an employee table?..

Answer / radha sri seshu.kolla

1)SELECT MAX(SAL) FROM EMP WHERE LEVEL=3 CONNECT BY PRIOR
SAL>SAL
2)SELECT E.SAL FROM
(SELECT SAL,DENSE_RANK() OVER(ORDER BY SAL DESC)R FROM EMP)
E WHERE E.R=3

9966112520

Is This Answer Correct ?

10 Yes

5 No

how to check the 3rd max salary from an employee table?..

Answer / b.v.siva kumar

Use this for SQL Server:

select top 1 salary from emp where salary in (select
distinct top 3 salary from emp order by salary desc) order
by salary

Is This Answer Correct ?

5 Yes

0 No

how to check the 3rd max salary from an employee table?..

Answer / venkateswarulu.s

select min(salary) from emp where salary in(select distinct
top 3 salary from
emp order by salary desc)

Is This Answer Correct ?

13 Yes

10 No

how to check the 3rd max salary from an employee table?..

Answer / gourvendra singh

In oracle you can find the 3rd max salary with the help of
the command:-

select sal from(select sal from(select distinct sal from
emp order by sal desc)
where rownum <=3 order by sal asc) where rownum=1;

Is This Answer Correct ?

7 Yes

4 No

how to check the 3rd max salary from an employee table?..

Answer / ar

select c.emp_id,c.salary from (select rownum as
rn1,c.emp_id,c.salary from (select * from table_name ORDER
by salary DESC) b) c
where c.rn1 = n --(n=3)

Is This Answer Correct ?

2 Yes

0 No

how to check the 3rd max salary from an employee table?..

Answer / amit

select max(sal) from emp where sal<(select max(sal) from emp where sal<(select max(sal) from emp));

Is This Answer Correct ?

2 Yes

0 No

how to check the 3rd max salary from an employee table?..

Answer / danny

SELECT min( sal )
FROM emp
WHERE sal
IN (

SELECT DISTINCT sal
FROM emp
ORDER BY sal DESC
LIMIT 0 , 3
)

Is This Answer Correct ?

2 Yes

0 No

how to check the 3rd max salary from an employee table?..

Answer / neeraj79

SELECT DISTINCT salary
FROM employee
ORDER BY salary DESC
LIMIT(2,1)

Is This Answer Correct ?

2 Yes

0 No

how to check the 3rd max salary from an employee table?..

Answer / arjun

select min(sal) from (select sal from (select distinct(sal)
from emp order by sal desc) where rownum<4)

Is This Answer Correct ?

2 Yes

1 No

Post New Answer