SELECT * FROM (SELECT ROWNUM sl, salary FROM (SELECT DISTINCT

how to find the second highest salary in a given table????

Question Posted / mahesh

Answer Posted / mahesh

SELECT *
FROM (SELECT ROWNUM sl, salary
FROM (SELECT DISTINCT salary
FROM employees
ORDER BY salary))
WHERE sl = n

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is difference between sql plus and sql*plus? (not sql and sql plus).

3812

Explain the difference between replace() and translate() functions in oracle?

973

What is a cursor in oracle?

1106

What are advantages of dateset in datastage?

2198

How many memory layers are in the oracle shared pool?

1104

How to loop through a cursor variable?

1011

How to sort output in descending order in oracle?

987

Please explain oracle data types with examples?

990

How many types of tables are there in oracle?

1003

How to generate query output in html format?

1031

What is meant by joins?

1013

How to get last row id?

938

What is sharded cluster?

924

How to check database size in Oracle?

1115

How to convert numbers to characters in oracle?

967