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
What are the four Oracle system processes that must always be up and running for the database to be useable?
Explain the difference between a procedure and a function? What do you understand by those terms?
Who developed oracle & when?
How to invoke the data pump import utility?
How to write date and time literals in oracle?
What are the differences between blob and clob in oracle?
Respected sir, Please send me technical questions related to oracle apps..
What is object data modeling?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is data block in Oracle?
Will you be able to store pictures in the database?explain.
Explain what are the different type of segments?
What are the set operators union, union all, minus & intersect meant to do?
What do you mean by merge in oracle and how can you merge two tables?
How to assign data of the deleted row to variables?