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

How would you change old and new values in an insert, delete and update triggers?

1077

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1227

How to define a procedure inside another procedure?

1067

How can we force the database to use the user specified rollback segment?

1200

How to create a table in a specific tablespace?

1027

How do we create privileges in oracle?

1100

How to display row numbers with the records?

1136

What the is the diff between local index and global index. give some example.

1683

How to put more than 1000 values into an oracle in clause?

1085

Explain the use of log option in exp command.

1184

How do I know if oracle client is installed on windows?

1092

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2091

How to use "while" statements in oracle?

1377

Is truncate autocommit in oracle?

1147

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1931