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

Explain the use of rows option in exp command.

1025

What is ceil and floor in oracle?

1011

How to find out what oracle odbc drivers are installed?

979

What happens to the data files if a tablespace is dropped?

996

How to define an anonymous procedure with variables?

1065

How to Truncate Table in Oracle

1094

What is rich query?

929

How to list all user accounts in oracle?

981

Differentiate between post-database commit and post-form commit?

983

11. Display the client number and name and the client number and name of the person who referred that client.

2278

What is a trigger oracle?

1039

What do you understand by a database object?

990

What is a read write transaction in oracle?

1032

What is different types of joins?

969

What is set verify off in oracle?

1034