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

What is recovery manager in Oracle?

1108

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2203

Whether any commands are used for months calculation? If so, what are they?

1137

Why does Oracle not permit the use of PCTUSED with indexes?

2479

How to join two tables in a single query using oracle?

1052

What is oracle and what are its different editions?

1118

What is a dynamic performance view in oracle?

1057

What is the difference between hot backup and cold backup in oracle?

1076

How to add a new column to an existing table in oracle?

1186

What is meant by an index?

1219

What is materialized view in Oracle?

1114

How to start a new transaction in oracle?

1136

What is recycle bin in Oracle?

1195

Explain about functional dependency and its relation with table design?

1060

What is the difference between a hot backup and a cold backup in oracle?

1074