SELECT TOP 1 salary FROM ( SELECT DISTINCT TOP n salary FROM employee O

find out the second highest salary?

Question Posted / ved

Answer Posted / ved

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the use of aggregate functions in oracle?

992

What is ceil and floor in oracle?

1036

Is oracle a language?

914

What is the Tune Query

2251

Explain the difference between sap and oracle?

1003

what is the difference between restoring and recovering?

979

How many types of tables supported by oracle?

1037

What is Trigger in Oracle?

1107

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

5371

How to convert characters to times in oracle?

984

What is Undo Management Advisor in Oracle?

1062

How to import one table back from a dump file?

990

How do we represent comments in oracle?

1020

How to Truncate Table in Oracle

1119

What are the arithmetic operations?

1046