Interested to Buy Any Domain ? << Click Here >> for more details...
how will I find the first 5 highest salaried employees in
each dept in oracle.
- 22 Answers
- 32311 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / kanha
Select E1.* From(Select Ename,Deptno,Sal,
Dense_Rank()over
(
Partition By Deptno Order By Sal Desc
)"Top Sal"
From Emp)E1
Where "Top Sal"<=5 Order By Deptno,Sal Desc;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can objects of the same schema reside in different tablespace?
How does Oracle guarantee data integrity of data changes?
How many types of tables supported by oracle?
How to convert characters to times in oracle?
How to pass a parameter to a cursor in oracle?
How to use windows user to connect to the server?
Difference between oracle's plus (+) notation and ansi join notation?
What privilege is needed for a user to connect to oracle server?
Explain parameter file in oracle.
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
What is a tns service name?
How to find out what oracle odbc drivers are installed?
How do I limit the number of rows returned by an oracle query after ordering?
What do you understand by a database object?
