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

Explain about unique identifier data type in sql server?

596

How would you use user_constraints table in DB?

675

What is dynamic cursor in SQL SERVER?

633

How do I port a number to sql server?

597

What are different backups available in sql server?

688

What command is used to rename the database?

605

What is the recursive stored procedure in sql server?

607

Can an automatic recovery be initiated by a user?

657

What does it mean to invest in the index?

606

What is collation sensitivity? Explain different types.

641

What is the difference between DataRow.Delete() and DataRow.Remove()?

837

What is pessimistic concurrency?

625

What is an execution plan?

652

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

611

Describe in brief databases and sql server databases architecture.

604