how will I find the first 5 highest salaried employees in
each dept in oracle.
- 22 Answers
- 26874 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / karthik
select * from (select ename,eno,dept,sal,row_number() over
(partition by dept order by sal desc)top5 from emp) where
top5 <= 5
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
When do you get a .pll extension in oracle?
What are the differences between char and nchar in oracle?
What is the exact use of Collections?
What is oracle used for?
Explain oracle insert into command?
Explain a private synonyms?
What are the data types in oracle?
What are the various types of snapshots ?
What is literal?
Explain table?
What is a schema in oracle?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
How to use in conditions in oracle?
What is oracle open database communication (odbc)?
Explain what are the type of synonyms?
