Select E1.* From(Select Ename,Deptno,Sal, Dense

how will I find the first 5 highest salaried employees in
each dept in oracle.

Question Posted / kanha

22 Answers
32759 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

Please Help Members By Posting Answers For Below Questions

Explain the truncate in oracle?

965

Explain integrity constraints?

1102

What is the use of aggregate functions in oracle?

1023

What is recovery manager(rman) backup in Oracle?

1183

what are actual and formal parameters?

1104

How to loop through a cursor variable?

1082

Explain the importance of .pll extension in oracle?

1003

How to load a large xml file?

1051

How to recover a dropped table in oracle?

1037

Explain the dml?

974

What is oracle and what are its different editions?

1064

How to create additional tablespaces for an new database?

1022

Design database draw er diagram for a certain scenario ?

4577

What are ddl statements in oracle?

1075

How to compare dates in oracle sql?

1097