SELECT TOP 1 salary FROM ( SELECT DISTINCT TOP 3 salary FROM employee

Find out the 3rd highest salary?

Question Posted / vikram kumar

Answer Posted / vikram kumar

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is difference between cursor and trigger?

1037

What is record in pl sql?

1038

What is a constraint?

982

Why do we use function in pl sql?

1034

Is sqlexception checked or unchecked?

933

How does postgresql compare to oracle/db2/ms sql server/informix?

1001

How to call a javascript function from pl sql?

1096

What is the difference between an inner and outer join?

989

how can we submit a form without a submit button? : Sql dba

944

What is partition by in sql?

1024

what is bdb (berkeleydb)? : Sql dba

996

When to use inner join and left join?

927

Do we need commit after truncate?

1052

How do I count rows in sql?

968

when is the use of update_statistics command? : Sql dba

1006