find out the third highest salary?

Categories >> Software >> Databases >> Oracle >> Oracle General
Suggest New Category

Question Posted / guest

92 Answers
147672 Views
CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

find out the third highest salary?..

Answer / mihir nasikkar

Here n is 3

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary

Is This Answer Correct ?

2 Yes

0 No

find out the third highest salary?..

Answer / gayathri

if you compare the salary slip u can find

Is This Answer Correct ?

3 Yes

1 No

find out the third highest salary?..

Answer / karunakar varma

select a,sal from (select dense_rank() over (order by sal
desc) a,sal from emp) where a=3

Is This Answer Correct ?

4 Yes

2 No

find out the third highest salary?..

Answer / abbas

SELECT * FROM
(
SELECT EMPLOYEECODE, SAL, Rank() OVER (ORDER BY SAL DESC )
RANKNEW FROM EMPLOYEE)
WHERE RANKNEW = 3

Is This Answer Correct ?

9 Yes

8 No

find out the third highest salary?..

Answer / mahesh

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

Is This Answer Correct ?

11 Yes

10 No

find out the third highest salary?..

Answer / nirad

select Top 1 *
from ( select top 3 * from Customer order by salary desc )
tempt
order by salary asc

if you want third lowest just desc with asc and asc with
desc and even if you want 2 or other hight value just
change inner query value of 3

Is This Answer Correct ?

3 Yes

2 No

find out the third highest salary?..

Answer / chinmaya

Select Top 1 Sal from (Select Top 3 Sal from emporder by
Sal desc) x order by Sal

Is This Answer Correct ?

1 Yes

0 No

find out the third highest salary?..

Answer / vanaja

select * from emp5 where salary in(select min(salary) from
emp5 where salary in(select top 3 salary from emp5 order by
salary desc))

Is This Answer Correct ?

1 Yes

0 No

find out the third highest salary?..

Answer / sam

Guys
See the correct answer.

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

Is This Answer Correct ?

2 Yes

1 No

find out the third highest salary?..

Answer / ajit

SQL QUERIES FOR FINDING Nth HIGHEST SALARY

SELECT DISTINCT (a.salary) FROM EMPLOYEES A WHERE &N = (SELECT COUNT (DISTINCT (b.salary)) FROM EMPLOYEES B WHERE a.salary<=b.salary);

Is This Answer Correct ?

1 Yes

0 No

Post New Answer