Select * from (Select Dense_Rank() over ( Partition by department

i want department wise maxmum salary and empolyee name

Question Posted / sai krishna

Answer Posted / sai krishna

Select * from (Select Dense_Rank() over ( Partition by department_id Order by salary desc) as Rnk,E.* from HR.Employees E) where Rnk=1;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to return top 5 rows in oracle?

1069

How to create a new view in oracle?

1079

Are truncate and delete commands same? If so why?

1158

How index is implemented in oracle database?

1009

Why oracle is used?

1064

How to list all tables in your schema?

1055

How to create a table interactively?

1097

How would you go about verifying the network name that the local_listener is currently using?

2050

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3207

What is rich query?

986

How to start instance with a minimal initialization parameter file?

1048

How do I call oracle stored procedures that take no parameters?

1123

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1915

How to count duplicated values in a column in oracle?

1050

What is where clause in oracle?

1032