please tell me the query to get details of the employee
having the second largest salary
Answer Posted / ram
SELECT TOP 1 ESAL
FROM
(
SELECT DISTINCT TOP 2 ESAL
FROM EMPLOYEE
ORDER BY ESAL DESC
)ABC
ORDER BY ESAL ASC
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What does executeupdate return?
Explain different types of Normalization.
Explain features of analysis services?
Explain transaction isolation levels in sql server?
When you use @@error and try-catch?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
What is an example of a primary key?
What is resultset concur_updatable?
How to recompile stored procedure at run time?
What is sql server transaction log file?
What is BLOCK statements in SQL?
What are parameterized reports? What are cascading parameters in ssrs reports?
What is indexing explain it with an example?
What is SQL Server?
How to connect to SQL Azure Database by using sqlcmd?