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

Find out the 3rd highest salary?

Question Posted / himanshu

Answer Posted / himanshu

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 the difference between an inner join and an outer join?

988

What is the difference between null value, zero, and blank space?

1156

Does sql between include endpoints?

970

what are the types of subquery? : Sql dba

1067

What is schema in sql example?

1123

Is left join same as join?

954

How do I find sql profiler?

900

Explain what is rdbms?

1009

Is record in oracle pl sql?

921

What are sql queries used for?

995

Why is nosql good?

993

what is the difference between cluster and non cluster index? : Sql dba

979

What are the different types of a subquery?

1005

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

918

What is pl sql package?

1006