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

what is a relationship and what are they? : Sql dba

1073

What is difference between table and view?

1032

How many types of functions are there in sql?

929

Can you join views in sql?

936

How exception is different from error?

1002

What is application trigger?

976

what is column? : Sql dba

988

Who developed sql?

1018

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1245

What is rowid in sql?

958

What are tables and fields?

1012

What do you understand by case manipulation functions?

1009

How can you load multi line records? : aql loader

1064

What are the two parts of design view?

1003

Explain the update statement in sql

966