SELECT sal FROM (SELECT sal FROM emp ORDER BY sal desc) WHERE RowN

Write a query to find second highest salary of an employee.

Question Posted / gautam poonia

Answer Posted / gautam poonia

SELECT sal
FROM (SELECT sal FROM emp
ORDER BY sal desc)
WHERE RowNum<=2
minus
SELECT sal
FROM (SELECT sal FROM emp
ORDER BY sal desc)
WHERE RowNum<=1

Is This Answer Correct ?

17 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Why we use cross join?

952

What is the purpose of the partition table?

1049

What is the best sql course?

984

what is rdbms? : Sql dba

1012

What does count (*) mean?

929

is it possible to pass an object or table to a procedure as an argument?

1135

What information is needed to connect sql*plus an oracle server?

1028

Explain how can you save or place your msg in a table?

1028

What is set serveroutput on?

1136

How to run sql functions in pl/sql?

1054

How many types of primary keys are there?

1038

Explain dml and ddl?

996

What are conditional predicates?

1060

What is a delimiter in sas?

1056

Explain the advantages and disadvantages of stored procedure?

1148