SELECT TOP 1 * FROM [SELECT TOP 3 * FROM Emp_Salary ORDER BY Salary DESC;]

how to check the 3rd max salary from an employee table?

Question Posted / neeraj

Answer Posted / neeraj

SELECT TOP 1 * FROM [SELECT TOP 3 * FROM Emp_Salary
ORDER BY Salary DESC;]
ORDER BY Salary;

Is This Answer Correct ?

3 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is varray in pl sql?

1008

What is a call statement? Explain with an example.

954

Is coalesce faster than isnull?

909

What is loop in pl sql?

984

What is sql used for?

1066

What is benefit of creating memory optimized table?

910

How to display the current date in sql?

1011

Why triggers are used?

939

what are ddl statements in mysql? : Sql dba

1114

What is the most common sql injection tool?

997

how to show all tables with 'mysql'? : Sql dba

1060

what are all the common sql function? : Sql dba

1013

What is the non-clustered index in sql?

1011

What is pivot table in sql?

1019

What is trigger in sql?

1030