sql satement for 2nd maximum value

Answer Posted / sanjay

select top 1 EmployeeID,min(Rate ) from
(select top 2 EmployeeID ,Rate from
EmployeePay
order by Rate desc)table1 group by EmployeeID ,Rate

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why should you use delegate?

540


Explain about branching logic control in vb.net?

609


What is redim keyword and its use?

675


What do you understand by vb.net?

688


What is visual basic.net culture?

586






Explain the difference between int and int32?

591


How vb implements the disconnected architecture as like vb.net?

660


Explain the difference between thread and process?

580


Why is the xml infoset specification different from the xml dom?

607


Why do we use byref keyword in vb.net?

697


Did vb6 support multi-threading ?

617


What is internal keyword in .net framework?

714


What is the top .net class that everything is derived from?

700


What is late binding and early binding?

636


What are the differences between c# and visual basic.net?

610