select distinct top 1 salary from payroll..emp where salary 
in(select distinct top N salary from payroll..emp order by 
salary desc)

if u want top 2 put 2 at the pacece of N
if u want top 5 put 5 at the pacece of N
if u want ..............................