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
Which environment variables are absolutely critical in order to run the OUI?
What are the general rules on data consistency?
Explain drop constraint oracle?
How would you change old and new values in an insert, delete and update triggers?
What is MTTR advisor in Oracle?
How to list all user accounts in oracle?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What are the oracle built-in data types?
What is the difference between substr and instr?
How to get a list of all background sessions in the database?
how may join possible between (requisition with purchase order)
Please explain compound trigger in oracle?
if you ctreate table identity
What happens if you set the sga too low in oracle?
What is the difference between post-database commit and post-form commit?