find out the third highest salary?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
What is a heap related to database ?
1 Answers TCS, University of Edinburgh,
How to start instance with a minimal initialization parameter file?
how can we write trigger in trigger???????? can we write one trigger on two table???
How to convert a date to char in oracle? Give one example.
What is clustered table in Oracle?
How to update a table row with a record?
Youre getting high busy buffer waits - how can you find whats causing it?
What is the maximum number of triggers that can be applied to a single table?
What is sequence?
What is forall Statement ?
Explain the use of grant option in exp command.
How to use "for" statements in oracle?