SELECT TOP 1 ESAL FROM ( SELECT DISTINCT TOP 2 ESAL FROM EMPLOYEE ORDE

please tell me the query to get details of the employee
having the second largest salary

Question Posted / ram

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

Please Help Members By Posting Answers For Below Questions

What does executeupdate return?

926

Explain different types of Normalization.

1733

Explain features of analysis services?

922

Explain transaction isolation levels in sql server?

1034

When you use @@error and try-catch?

982

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1853

What is an example of a primary key?

911

What is resultset concur_updatable?

968

How to recompile stored procedure at run time?

1005

What is sql server transaction log file?

992

What is BLOCK statements in SQL?

1205

What are parameterized reports? What are cascading parameters in ssrs reports?

148

What is indexing explain it with an example?

930

What is SQL Server?

1147

How to connect to SQL Azure Database by using sqlcmd?

136