select * from (select ename,sal,deptno,dense_rank() over(partition by dept

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

Question Posted / nagaraju nampally

Answer Posted / nagaraju nampally

select * from (select ename,sal,deptno,dense_rank()
over(partition by deptno order by sal)rnk from emp)x where
x.rnk<5

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Â How to use an oracle sequence generator in a mapping?

1076

How do we create privileges in oracle?

1047

What is a connect identifier?

1039

How much memory your 10g xe server is using?

1103

What is control file used for?

1209

How to filter out duplications in the returning rows using oracle?

1018

What happens if you use a wrong connect identifier?

1065

How to use an explicit cursor without open statements?

1055

6. Display the client name and order date for all orders using the traditional method.

2308

How to select some rows from a table in oracle?

1078

How to use "if" statements on multiple conditions?

1174

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4523

how to make an oracle object

2359

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1934

How oracle handles dead locks?

1066