Select * from EmpTbl Where Salary = (Select Max(Salary) from EmpTbl Where

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

Question Posted / devendra dwivedi

Answer Posted / devendra dwivedi

Select * from EmpTbl Where Salary = (Select Max(Salary) from
EmpTbl Where Salary < (Select Max(Salary) from EmpTbl)

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to create user defined functions with parameters?

1235

Where is trigger in sql server?

1045

How many types of database relationship in sql server?

1054

What are the operating modes in which database mirroring runs?

1089

How to verify a user name with sqlcmd tool?

1080

How to write a query with an inner join in ms sql server?

1047

Is there any difference between the primary key and unique key?

1000

How can we migrate from SQL server to SQL Azure?

113

Explain primary key, foreign key and unique key?

993

What are the limitations in ssrs on sql server express edition?

186

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2752

What is collation sensitivity? Explain different types.

1010

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

923

What does the on delete cascade option do?

1017

Where are sql server user names and passwords stored in sql server?

1092