Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 151305 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
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 are the execution control statements in oracle?
How to restrict the duplicate records in table valuesets
Does a Before form trigger fire when the parameter form is suppressed ?
What is catalog in Oracle?
What do you understand by a database object?
How to use "if" statements on multiple conditions?
How to convert characters to numbers in oracle?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
How to Truncate Table in Oracle
when i run my query on yesterday it is fast but today it is slow why?
How to use an explicit cursor without open statements?
What is difference between truncate and delete?
Oracle General 
