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
What are operators in oracle?
What exactly do quotation marks around the table name do?
How to use attributes of the implicit cursor in oracle?
What is a table index in oracle?
List the various oracle database objects?
What is enter substitution variable in oracle?
How to login to the server without an instance?
How to fetch the row which has the max value for a column?
What is oracle and what are its different editions?
how to do daily transactions with out sql* loader control file regesterd in apps?
how can we store any pdf file in oracle
What is the difference between online and offline backups?
Respected sir, Please send me technical questions related to oracle apps..
What is tns entry?
What happens to the indexes if a table is recovered?