Select Min(Salary) From (Select Top N * From Table

please tell me the query to get details of the employee
having the second largest salary

Question Posted / ajay sara

Answer Posted / ajay sara

Select Min(Salary) From (Select Top N * From Table_Name
Order by Salary Desc)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Write the syntax for stuff function in an sql server?

1032

Can you use order by when defining a view?

980

Mention a few common trace flags used with sql server?

940

What is SQL Server?

1220

What do you understand by coalesce in sql server?

1079

Is it possible in sql table to have more than one foreign key?

1040

What is schemabinding a view?

923

Can we check locks in database? If so, how can we do this lock check?

948

Write a sql query to delete duplicate records from a table called table1

1041

what method you can use to reduce the overhead of Reporting Services data sources?

255

How will you make an attribute not process? : sql server analysis services, ssas

1095

What is 2nf normalization?

1033

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

994

What is the difference between a clustered index and a non-clustered index?

991

Is foreign key unique?

1006