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

How to encrypt Strored Procedure in SQL SERVER?

1229

Can we use where and having clause together?

1099

Can we update data in a view?

1081

What is key attribute?

983

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

989

What is the Disadvantage of indexed sequential file.

1130

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2114

What the different types of Replication and why are they used?

1133

What are the results of running this script?

976

What are filegroups in sql server?

1103

What are the different types of Indexes available in SQL Server?

1059

Explain what is it unwise to create wide clustered index keys?

1023

What is a trace frag?

1136

How to loop through the result set with @@fetch_status?

1442

Tell me extended events in sql server 2008?

1055