Here n is 3 SELECT TOP 1 salary FROM ( SELECT DISTINCT TOP n salary

find out the third highest salary?

Question Posted / mihir nasikkar

Answer Posted / mihir nasikkar

Here n is 3

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

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What privilege is needed for a user to query tables in another schema?

1030

What is a nested table?

1111

How to best split csv strings in oracle 9i?

1097

Explain the use of inctype option in exp command.

1081

How to view the data files in the current database?

1147

Are truncate and delete commands same? If so why?

1201

What are the extensions used by oracle reports?

1089

How to drop an existing table in oracle?

1102

How to create a single index for multiple columns?

1080

Explain an integrity constrains?

1190

What are the different editions of oracle?

1178

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

3021

How to specify default values in insert statement using oracle?

1152

What is the quickest way to export a table to a flat file?

1010

What is system tablespace?

1148