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
Can you index views?
What stored by the master?
What are different types of collation sensitivity?
What is optimization and its types?
What is the process of indexing?
What is a natural primary key?
What structure can you implement for the database to speed up table reads?
Why olap is used?
between cast and convert which function would you prefer and why?
What is database architecture? : SQL Server Architecture
How you can add messages to the nt event log from within a stored procedure?
Describe the functionalities that views support.
Tell me when is the update_statistics command used?
How to add more data to the testing table in ms sql server?
What is log in sql server?