SELECT * FROM(SELECT *,DENSE_RANK() OVER(PARTITION BY DEPTNO ORDER BY SAL D

i need department wise top 2 employees salary.which logic
i will use

Question Posted / naresh anumolu

Answer Posted / naresh anumolu

SELECT * FROM(SELECT *,DENSE_RANK() OVER(PARTITION BY DEPTNO ORDER BY SAL DESC) AS RANK FROM EMP)A WHERE RANK<3

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How many postgresql users are there, worldwide?

992

What are the different schemas objects that can be created using pl/sql?

967

What is the meaning of disabling a trigger?

1111

What is an exception in pl/sql?

1006

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1176

Why triggers are used?

937

What is pivot table in sql?

1017

how can we destroy the cookie? : Sql dba

959

Why do we use partitions in sql?

976

Why use subqueries instead of joins?

1031

What is scalar function?

999

What is union, minus and interact commands?

1213

What does where 1/2 mean in sql?

1007

How many tables can a sql database have?

925

How much does sql certification cost?

1015