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 is difference between commit and rollback when used in transactions?

967

What is change tracking in sql server?

1030

is it important for a database administrator to understand the operating system and file access? : Sql server administration

1038

How to send a ssrs report from ssis?

177

Can you tell me some of the common replication dmv's and their use? : sql server replication

931

What are difference between Cluster index and Non-Cluster index?

1082

Explain about local stored procedure?

976

Explain the difference between functions and stored procedures in sql server?

985

List out what other servers you can use with ssrs?

139

How to perform backup for certificates in sql server? : sql server security

1101

How to delete duplicate rows from table except one?

995

What is the primary use of the model database?

1092

Do you know nested transaction?

964

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

947

do views contain data ?

976