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

Observations between vb.net and vc#.net?

580


What is a preprocessor directive in vb.net?

554


What is sorting in vb?

532


What is misl code?

577


How to store images in sql server database through vb.net?

511






Explain how to achieve polymorphism in vb.net?

553


What is the difference between manifest and metadata?

556


Which is the base class for all the classes in .net framework?

571


Explain the difference between import system.data.sqlclient and system.data.oledb?

559


What is trace in vb.net?

596


What is the strong name in .net assembly?

577


What is internal keyword in .net framework?

634


Explain public assembly?

563


Explain about the keyword must inherit?

593


What is the difference between convert.tostring and i.tostring method?

563