how will I find the first 5 highest salaried employees in
each dept in oracle.
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 |
What is recovery manager(rman) backup in Oracle?
What is the use of Redo Log Information ?
What is a nvl function? How can it be used?
Explain the use of record option in exp command.
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
How many types of synonyms in Oracle?
When does a Transaction end ?
Where are the settings stored for each instance in oracle?
How to update values on multiple rows in oracle?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Whether any commands are used for months calculation? If so, what are they?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?