how will I find the first 5 highest salaried employees in
each dept in oracle.
Answer Posted / jas
select a.sal,a.emp_no from employee a
where 5=(select distinct(count(*) from
employee b where a.sal> b.sal)
Is This Answer Correct ? | 8 Yes | 9 No |
Post New Answer View All Answers
Explain alias?
What is a nested table and how is it different from a normal table?
What are the different pseudo commands? Explain in general?
Explain an exception?
What is set operator oracle?
What is parameterized cursor in oracle?
How a tablespace is related to data files?
What to do if the binary spfile is wrong for the default instance?
What privilege is needed for a user to create indexes in oracle?
Which is better Oracle or MS SQL? Why?
What is varray?
What is key preserved table?
What is the purpose of save points in oracle database?
How do I find my oracle client driver version?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??