Dotnet Technical
Friday, July 29, 2011
Nth Highest salary
declare @empsal int
set @empsal=3
select * from [Employee-new] e1 where @empsal =( select count(distinct e2.empsal) from [Employee-new] e2 where e2.empsal >= e1.empsal)
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)