Find out the 3rd highest salary?

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

Question Posted / guest

51 Answers
72138 Views
BirlaSoft, DAC, Silvia Infotech, Sutra Infotech, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Find out the 3rd highest salary?..

Answer / shruti

select empno,sal from
(select empno,sal from emp order by sal desc)
where rownum<4

Is This Answer Correct ?

2 Yes

0 No

Find out the 3rd highest salary?..

Answer / tathagoto

select min(sal) from (select sal from (select sal from
salary order by sal desc) where rownum <
4);

Is This Answer Correct ?

4 Yes

3 No

Find out the 3rd highest salary?..

Answer / sathiskumar

select min(sal) from (select top 3 salary from employee);

Is This Answer Correct ?

1 Yes

0 No

Find out the 3rd highest salary?..

Answer / av.anil

SELECT * FROM
(SELECT Ename,Sal,
DENSE_RANK()
OVER(ORDER BY Sal DESC) "D_RK"
FROM Emp)
WHERE D_RK = 3;

This query gives exact highest salary.

Is This Answer Correct ?

1 Yes

0 No

Find out the 3rd highest salary?..

Answer / jagdish

select max(sal) from emp where sal!=(select max(sal) from
emp where sal!=(select max(sal) from emp))

Is This Answer Correct ?

1 Yes

0 No

Find out the 3rd highest salary?..

Answer / vivek

SELECT v.Emp_Sal
FROM Employee_Test v
WHERE 3=
(
SELECT COUNT(DISTINCT z.Emp_Sal)
FROM Employee_Test z
WHERE v.Emp_Sal<=z.Emp_Sal
)

Is This Answer Correct ?

1 Yes

0 No

Find out the 3rd highest salary?..

Answer / shibin k abraham

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

Is This Answer Correct ?

1 Yes

0 No

Find out the 3rd highest salary?..

Answer / priyanga.g

1) Select MAX(salary) from Programmer where salary not
in(select top 2 salary from Programmer order by salary desc)

2) Select max(salary) from programmer where salary<
(select MAX(salary) from Programmer where salary<(select
MAX(salary) from Programmer))

3) Select MAX(salary) from Programmer e where 2=(select
COUNT(*) from programmer b where b.salary>e.salary )

Is This Answer Correct ?

1 Yes

0 No

Find out the 3rd highest salary?..

Answer / ratnakar

select max(sal) from emp a where 3=(select count(sal) from
emp b where b.sal >=a.sal;

Is This Answer Correct ?

10 Yes

10 No

Find out the 3rd highest salary?..

Answer / sheik

select top 1 * from(select top 3 *from emp order by salary
desc)d order by salary asc

Is This Answer Correct ?

0 Yes

0 No

Post New Answer