SELECT * FROM ( SELECT e1.*, &

Query for second maximum salary in each in each department

Question Posted / swas

Answer Posted / swas

SELECT *
FROM
(
SELECT e1.*,
DENSE_RANK() OVER(PARTITION BY Deptno
ORDER BY Sal DESC
)TopRank
FROM Emp e1
)
WHERE TopRank = 2
/

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a composite primary key?

1085

Difference between global and parameter variables?

1963

discuss about myisam index statistics collection. : Sql dba

949

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2012

what are all types of user defined functions? : Sql dba

1042

What are pl/sql cursor exceptions?

1098

what is sql in mysql? : Sql dba

1185

Is sqlite thread safe?

1043

What does (+) mean in sql joins?

1059

How many sql commands are there?

1114

Can we create foreign key without primary key?

981

Explain foreign key in sql?

1018

What is difference between db2 and sql?

997

What is optimistic concurrency control? : Transact sql

981

How do I view a procedure in sql?

963