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 Unique and Primary Key Constraints?

1111

Is sql a backend language?

1100

Is merge a dml statement?

984

How do I save a stored procedure?

1012

What is trigger in sql? Explain

999

What is scalar function?

1058

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1241

What are the types of triggers in sql?

1091

what are date and time data types? : Sql dba

991

What is dynamic query?

983

what is a constraint? : Sql dba

1181

What programs use sql?

1017

What is difference between stored procedures and application procedures?

1022

what are all the common sql function? : Sql dba

1062

What is sql indexing?

1016