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 acid db?
When multiple after triggers are attached to sql table, how to control the order of execution?
Which language rdl files made of?
how will add additional conditions in sql?
What is resultset concur_updatable?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
What is a transactions?
Explain DBCC?
How to create a store procedure with encryption?
Why the trigger fires multiple times in single login?
What is inner join in sql server joins?
Give an example of SQL injection attack ?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What is the use of commit?
What are the differences between decimal and float in ms sql server?