how will I find the first 5 highest salaried employees in
each dept in oracle.
Answer Posted / ravindra reddy
select *from(select b.* from emp b order by sal desc)where rownum<=5 order by sal desc
------------------------------------------------------------
select *from(select b.*,rank() over(order by sal desc) from emp b)where rownum<=5
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to convert numbers to characters in oracle?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
How to test null values?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
In oracle there is column command, how will you explain that?
How to use like conditions in oracle?
How to delete all rows a table in oracle?
What is oracle used for?
What is a procedure in oracle?
What is tns entry?
What is a trace file and how is it created in oracle?
How to recover a dropped table in oracle?
How to use attributes of the implicit cursor in oracle?
Is oracle a language?
What do you mean by a deadlock?