SELECT * FROM ( SELECT DEPARTMENT_ID,SALARY,DENSE

select top 3 sal from each dept?

Question Posted / shailesh j

Answer Posted / shailesh j

SELECT * FROM (
SELECT DEPARTMENT_ID,SALARY,DENSE_RANK() OVER(PARTITION BY
DEPARTMENT_ID ORDER BY SALARY DESC) AS RK FROM EMPLOYEES)
WHERE RK<4;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain autonomous transaction.

1126

Can we change the table name in sql?

913

What is dense_rank in sql?

936

What are procedures used for?

943

What is the use of sql trace?

923

How do you create a db file?

978

How do you write a complex sql query?

1032

What is the difference between left outer join and left join?

962

What is pl sql script?

995

how to load data files into tables with 'mysqlimport'? : Sql dba

1062

Which are the different case manipulation functions in sql?

977

Is grant a ddl statement?

871

What does the file extension accdb stand for?

938

explain mysql aggregate functions. : Sql dba

958

Explain what is sql*plus?

1108