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)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment