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
What is meant by indexing?
How to get a list of columns in a view using the "sp_columns" stored procedure?
what is the sql equivaent of the dataset relation object ?
What is t-sql script to take database offline – take database online.
Explain what are the different index configurations a table can have?
What is data set in report?
How to automatically create a log when an exception is being received into SQL Server?
What is a file group?
What is change data capture (cdc) feature?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What is federation member?
What is trigger in salesforce?
How to resolve the orphan use problem? : sql server security
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
How will you add a dimension to cube? : sql server analysis services, ssas