how will I find the first 5 highest salaried employees in
each dept in oracle.
- 22 Answers
- 27009 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
How do I escape a reserved word in oracle?
Explain integrity constraints?
How to connect to the server with user account: sys?
How do we display rows from the table without duplicates?
Explain the difference between sap and oracle?
What is a sub query? What are its various types?
What is the max number of columns in an oracle table?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
Can we commit inside a function in oracle?
How to unlock the sample user account in oracle?
When do you get a .pll extension in oracle? Explain its importance
what is the difference between substr and instr function in oracle?
How to loop through data rows in the implicit cursor?
Point out the difference between user tables and data dictionary?
How to save query output to a local file?
