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

How many data types are supported?

1085

What do database buffers contain?

1040

what's query optimization and without use of IN AND Exist can we get another way data from query

2147

Is there a combination of "like" and "in" in sql?

1070

Explain a synonym?

1034

How to invoke the original export import utilities?

1069

How to speed up webrick?

1080

How to sort output in descending order in oracle?

1049

Why does oracle 9i treat an empty string as null?

1063

How do I connect to oracle?

1035

What is PL/SQL ?

2080

Is postgres faster than oracle?

1047

What are the different oracle database objects?

1098

How to drop an index?

966

How can windows applications connect to oracle servers?

1060