how will I find the first 5 highest salaried employees in
each dept in oracle.
- 22 Answers
- 29411 Views
- IBM, I also Faced
- E-Mail Answers
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
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
How to handle a single quote in oracle sql?
What is the exact use of Collections?
What is ordinary table in oracle?
How to filter out duplications in the returning rows using oracle?
What is an external table?
What is oracle and what are its different editions?
How do I start tns listener?
What is a nested table?
What is a user role in oracle?
what are archived logs?
What is format trigger?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
Explain the different normalization forms?
