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

interview questions with answer for cts

2534

Explain the use of owner option in exp command.

994

How to rename an index?

997

How to define an oracle sub procedure?

1058

What are the differences between date and timestamp in oracle?

974

Which are the five query types available in oracle?

897

Can you have more than one content canvas view attached with a window ?

2264

What are the limitations oracle database 10g xe?

979

What are the different types of partitions in oracle?

911

What is Undo Management Advisor in Oracle?

1042

How to use subqueries with the exists operator in oracle?

972

What suggestions do you have to reduce the network traffic?

902

How to use "in out" parameter properly?

1000

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2251

How do I spool in oracle?

940