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

What is acid db?

933

When multiple after triggers are attached to sql table, how to control the order of execution?

1108

Which language rdl files made of?

141

how will add additional conditions in sql?

1170

What is resultset concur_updatable?

1055

Write the queries for commands like Create Table, Delete table, Drop Table etc.

1170

What is a transactions?

1090

Explain DBCC?

1016

How to create a store procedure with encryption?

1057

Why the trigger fires multiple times in single login?

1282

What is inner join in sql server joins?

1100

Give an example of SQL injection attack ?

1053

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

1097

What is the use of commit?

1063

What are the differences between decimal and float in ms sql server?

1351