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

Can you index views?

494


What stored by the master?

537


What are different types of collation sensitivity?

534


What is optimization and its types?

527


What is the process of indexing?

508






What is a natural primary key?

515


What structure can you implement for the database to speed up table reads?

701


Why olap is used?

555


between cast and convert which function would you prefer and why?

525


What is database architecture? : SQL Server Architecture

541


How you can add messages to the nt event log from within a stored procedure?

561


Describe the functionalities that views support.

644


Tell me when is the update_statistics command used?

504


How to add more data to the testing table in ms sql server?

544


What is log in sql server?

582