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
Why use resource manager in Oracle?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
How would you go about verifying the network name that the local_listener is currently using?
What is the meaning of recursive hints in oracle?
What is a procedure in oracle?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
Explain self joins in oracle?
How to connect to a remote server?
What is a dead lock in oracle?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
ABOUT IDENTITY?
How different is ms access and oracle?
Describe the types of sub query?
What are the roles of dba?