how will I find the first 5 highest salaried employees in
each dept in oracle.
Answer Posted / praveen marigaddi.
select distinct sal from emp a where 5 >(select count
(distinct sal) from emp where sal>a.sal) order by a.sal desc
Is This Answer Correct ? | 6 Yes | 6 No |
Post New Answer View All Answers
How to calculate date and time differences in oracle?
What is the order of defining local variables and sub procedures/functions?
Explain about achiever in sql?
What is a relational database management system?
What is the maximum number of triggers that can be applied to a single table?
How can I see all tables in oracle?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Explain how you would restore a database using RMAN to Point in Time?
Can we store images in oracle database?
Why do we use bulk collect in oracle?
How a tablespace is related to data files?
What are the different types of modules in oracle forms?
What is merge statement used for?
How to do clean up if create database failed?
What is varray?