SELECT * from (SELECT * FROM emp ORDER BY sal DESC) WHERE rownum <= 2

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / sushma

Answer Posted / sushma

SELECT * from
(SELECT * FROM emp ORDER BY sal DESC)
WHERE rownum <= 2
MINUS
SELECT * from
(SELECT * FROM emp ORDER BY sal DESC)
WHERE rownum < 2

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How does left join work in sql?

1006

What is the use of <> sql?

980

What does trigger mean in psychology?

962

can sql servers linked to other servers like oracle? : Sql dba

1009

How does sql developer connect to oracle database?

1005

how to select unique records from a table? : Sql dba

1114

How to call a javascript function from pl sql?

1143

What is the clause we need to add in function body to return variable?

1012

Explain the uses of a database trigger?

1043

What is the difference between a subquery and a join?

1109

What will you get by the cursor attribute sql%notfound?

1076

What is crud stand for?

998

Explain about various levels of constraint.

949

What does fetching a cursor do?

1090

Is left join inner or outer by default?

1020