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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List some case manipulation functions in sql?

773


Why use identity in sql server?

723


how you can configure a running aggregate in SSRS?

131


What are orphan records?

707


Can you insert NULL in unique column?

826






Explain different types of self contained sub query?

731


What is the difference between osql and query analyzer?

721


What is global temp table?

745


How to update values in a table with update statements in ms sql server?

737


What are out-of-range errors with date and time literals?

721


What is postgresql server?

689


List out a number of the wants to setup a SQL Server failover cluster?

750


What is logon trigger?

716


How do users use Report Builder with SQL Server data sources?

129


Explain about Views?

765