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

what are ddl statements in mysql? : Sql dba

1192

What is sql partition?

1105

What are sql*plus environment variables?

1093

What is the difference between python and sql?

995

Is null operator in sql?

1027

What is implicit cursor in pl sql?

1090

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1143

What operating systems are supported by oracle sql developer?

952

What is pls integer?

1033

What is compound trigger?

1032

What does where 1 1 mean in sql?

1035

How many types of functions are there in sql?

949

What are the two types of cursors in pl sql?

1073

Is not equal in sql?

1010

What port does sql server use?

1057