Interested to Buy Any Domain ? << Click Here >> for more details...
how will I find the first 5 highest salaried employees in
each dept in oracle.
- 22 Answers
- 32925 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sunil panghal
select rownum as row_id,salary from (select salary from
employees order by salary) where rownum <6;
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / rammohan
select rownum as row_id,sal from (select sal from
emp order by sal desc) where rownum <6;
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / uttam
select sal from (SELECT distinct sal FROM emp order by sal
desc)
where rownum <6
| Is This Answer Correct ? | 13 Yes | 15 No |
Answer / manjusure@yahoo.co.in
select * from emp e where 5> (select count(max(sal)) from emp
where e.deptno=deptno and sal>e.sal group by sal);
| Is This Answer Correct ? | 4 Yes | 6 No |
Answer / mihir nasikkar
select *
from employee X
where salary in (select top 5 salary
from employee
where dept = X.dept
order by salary desc)
order by dept, salary desc
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / mangesh
SELECT * FROM (SELECT * FROM EMP ORDER BY SALARY desc) WHERE ROWNUM < 6;
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / md valiyullah
select max(sal)-5 from emp where dept = 'sale'
union all
select max(sal)-5 from emp where dept = 'purchase'
| Is This Answer Correct ? | 0 Yes | 4 No |
Answer / dhanalakshmi
select salary
from employee
where rownum<6
group by deptno,salary
order by salary desc
| Is This Answer Correct ? | 0 Yes | 9 No |
How to view the data files in the current database?
What are the arithmetic operations?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
how to tune oracle sql queries pls tell me step by step. urgent pls
What are the most common interview questions on ETL Testing for experience?
How to rename an existing table?
What are the set operators union, union all, minus & intersect meant to do?
What are the components of logical database structure in oracle database?
In Oracle 9i what does "i" Stands for?
what is primary key?
Can we commit inside a function in oracle?
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
Oracle General 
