SELECT * FROM ( SELECT Ename, Deptno,

Query for second maximum salary in each in each department

Question Posted / swastik

Answer Posted / swastik

SELECT *
FROM
(
SELECT Ename, Deptno, Sal,
DENSE_RANK(PARTITION BY Deptno
ORDER BY Sal DESC
)TopRank
FROM Emp
)
WHERE TopRank = 2

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is pl sql architecture?

924

Who developed sql?

963

Can we alter stored procedure?

945

What are sql data types?

953

How to use distinct and count in sql query? Explain

961

Are subqueries faster than joins?

955

Explain the working of primary key?

1038

What is the primary use of normalization?

944

Can we join 3 tables in sql?

957

How sql query is executed?

1069

Is oracel sql developer written in java?

1060

Explain constraints in sql?

985

what is the use of friend function? : Sql dba

975

What is on delete set null?

1040

Explain ddl statements in pl/sql?

961