how will I find the first 5 highest salaried employees in
each dept in oracle.
Answer Posted / sreeharibabu
select * from (select emp.*,row_number() over(partition by deptno order by sal desc) rnk from emp) where rnk <=5 ;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO RNK
1 7839 X PRESIDENT 11/17/1981 5000.00 10 1
2 7782 X MANAGER 7839 6/9/1981 2450.00 10 2
3 7934 X CLERK 7782 1/23/1982 1300.00 10 3
4 700 X b 1234 9/9/2016 10:48:53 PM 1000.00 0.00 10 4
5 7369 X CLERK 7902 12/17/1980 8800.00 20 1
6 7788 X ANALYST 7566 4/19/1987 3000.00 20 2
7 7902 X ANALYST 7566 12/3/1981 3000.00 20 3
8 7566 X MANAGER 7839 4/2/1981 2975.00 20 4
9 7876 X CLERK 7788 5/23/1987 1100.00 20 5
10 7698 X MANAGER 7839 5/1/1981 2850.00 30 1
11 7499 X SALESMAN 7698 2/20/1981 1600.00 300.00 30 2
12 7844 X SALESMAN 7698 9/8/1981 1500.00 0.00 30 3
13 7521 X SALESMAN 7698 2/22/1981 1250.00 500.00 30 4
14 7654 X SALESMAN 7698 9/28/1981 1250.00 1400.00 30 5
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is meant by magic query
How to run queries on external tables?
Explain the use of tables option in exp command.
What is a subquery in oracle?
How to use "in out" parameter properly?
What is tns name?
What's dateware house and what's clustor with practicle example
What is the quickest way to export a table to a flat file?
How can I get column names from a table in oracle?
What do you mean by a tablespace?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What is connection pool in oracle?
What are the different types of trigger and explain its various uses and functions?
What are the oracle differences between nvl and coalesce
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?