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 is latest version of sql?

984

define sql delete statement ? : Sql dba

972

What are sql queries used for?

982

What is a loop in sql?

937

how to run 'mysql' commands from a batch file? : Sql dba

1063

explain the advantages and disadvantages of stored procedure? : Sql dba

957

Can a table contain multiple foreign key’s?

950

What is serial sql?

919

What is the use of triggers?

982

Do foreign keys improve performance?

968

Is sql a scripting language?

925

What is use of package in pl sql?

953

What does the file extension accdb stand for?

919

How do I send sql query results to excel?

1007

what is schema? : Sql dba

987