how will I find the first 5 highest salaried employees in
each dept in oracle.
Answer Posted / kanha
Select E1.* From(Select Ename,Deptno,Sal,
Dense_Rank()over
(
Partition By Deptno Order By Sal Desc
)"Top Sal"
From Emp)E1
Where "Top Sal"<=5 Order By Deptno,Sal Desc;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to assign values to data fields in record variables?
What are operators in oracle?
Explain the use of indexes option in imp command.
What is proxy method?
What is the oracle implicit cursor?
How do I manually uninstall oracle client?
What is varray?
What is clustered table in Oracle?
What are the different windows events activated at runtime ?
What are the types of partitions in oracle?
Can you have more than one content canvas view attached with a window ?
Explain integrity constraint?
How to add a new column to an existing table in oracle?
How many types of table in Oracle?
What is a private synonym?