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
- 32840 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
How to establish administrator authentication to the server?
How to load data through external tables?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
What is transaction control statement and how many types of transaction control statement in Oracle?
What is an anonymous block?
Where are the settings stored for each instance in oracle?
What is the difference between formal parameters and actual parameters?
When do I need to use a semicolon vs a slash in oracle sql?
What are privileges and grants?
What are the oracle differences between nvl and coalesce
Explain the features of oracle?
Please explain compound trigger in oracle?
WHAT IS ecc 6.0
Point the difference between translate and replace?
What are the ansi data types supported in oracle?
