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

Does oracle partitioning improve performance?

1051

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5476

What is coalesce function?

1144

Can you assign multiple query result rows to a variable?

1035

What is a snapshot in oracle database?

1070

Explain a synonym?

1086

How to use "in" parameter properly?

1118

List the parts of a database trigger.

1108

What happens to the current transaction if the session is killed?

1033

How to write a query with an inner join in oracle?

1094

How do I manually uninstall oracle client?

1148

Explain the function of optimizer in oracle?

1197

How to bring a tablespace online?

1137

How many types of segments in Oracle?

1114

How to update values on multiple rows in oracle?

1074