how will I find the first 5 highest salaried employees in
each dept in oracle.
Answer Posted / 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 |
Post New Answer View All Answers
Is rowid unique in oracle?
Can objects of the same schema reside in different tablespace?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
Is there a function to split a string in plsql?
types of indexes and the rationale behind choosing a particular index for a situation.
How do I uninstall oracle 11g?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
How to display employee records who gets more salary than the average salary in the department?
How to loop through a cursor variable?
What are internal user account in oracle?
How to view the tablespaces in the current database?
What is the relation of a user account and a schema?
what is normalisation?what are its uses?
What are the roles of dba?
What is a data dictionary and how can it be created?