find out the third highest salary?

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

Question Posted / guest

92 Answers
150663 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 / sanil

select first_name,salary from employees a
where (select count(distinct(salary)) from employees aa
where a.salary<=AA.SALARY) = &n;

Is This Answer Correct ?

0 Yes

5 No

find out the third highest salary?..

Answer / anish nama

select Max(salery) from salery where salery IN( select
top N salery from salery order by salery asc)

Is This Answer Correct ?

1 Yes

6 No

find out the third highest salary?..

Answer / hhh

select * from employee e where 3 = (select
count(distinct(salary)) from employee where e.salary <= salary);

Is This Answer Correct ?

0 Yes

5 No

find out the third highest salary?..

Answer / brijesh

hi,

this query gives you the Nth highest salary, the trick is to
write (N-1) in the given place;

select salary from table as table1

where (n-1) =

(select count(salary) from table

where table1.salary<salary);

Is This Answer Correct ?

0 Yes

6 No

find out the third highest salary?..

Answer / mamta

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

Is This Answer Correct ?

0 Yes

6 No

find out the third highest salary?..

Answer / amit sutar

select min(salary)

from(select distinct(salary)
from employees
order by salary desc)

where rownum<=5;

Is This Answer Correct ?

1 Yes

7 No

find out the third highest salary?..

Answer / alka

select min(salary)
from(select salary
from emp
order by salary desc
)
where rownum <=3

Is This Answer Correct ?

0 Yes

8 No

find out the third highest salary?..

Answer / tejeswara rao potnuru

Find Out The Nth Highest Salary

SELECT MAX(SAL),LEVEL FROM EMP
WHERE LEVEL=&LEVELNO
CONNECT BY PRIOR SAL>SAL
GROUP BY LEVEL;

Is This Answer Correct ?

0 Yes

8 No

find out the third highest salary?..

Answer / husenaiah.b

select empno,ename,sal from
(select empno,ename,sal from emp order by sal desc)
group by rownum,ename,sal having rownum=&n;
from this query we can find top nth sal

Is This Answer Correct ?

22 Yes

38 No

find out the third highest salary?..

Answer / naveen kumar

Hi everybody,
This is one way to get the third highest salary
select ROWNUM as RANK from (select * from emp order by sal)
where ROWNUM<=3

Is This Answer Correct ?

11 Yes

27 No

Post New Answer