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

In a distributed database system, can we execute two queries simultaneously?

1098

Does view store data in sql?

970

explain the delete statements in sql

1066

Why do we go for stored procedures?

1064

What is data type in database?

1001

What does cursor do in sql?

1031

what are the differences between char and varchar? : Sql dba

1078

What is the use of & in pl sql?

1049

How much does sqlite cost?

1047

What are the parameter modes supported by pl/sql?

1115

define sql delete statement ? : Sql dba

1026

Why we use stored procedure instead of query?

1003

Can instead of triggers be used to fire once for each statement on a view?

963

How do I turn a list into a table?

965

what is a database transaction? : Sql dba

1190