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

What do you understand by the denormalisation?

911

Do you know what is openxml in sql server?

1017

What is the difference between a check constraint and a rule?

1134

How do you size a resultset?

878

How to see the event list of an existing trigger using sys.trigger_events?

1026

What is the main purpose of having conversation group?

848

what's the information that can be stored inside a bit column? : Sql server database administration

967

What are horizontal and vertical scaling?

170

Does a server store data?

866

How to use union to merge outputs from two queries together in ms sql server?

1011

How to invoke a trigger on demand?

1029

How to convert binary strings into integers in ms sql server?

963

Explain about service Broker functions?

985

What is the difference between getdate and sysdatetime?

942

What is normalization according to you and explain its different levels?

900