query

select Distinct Top 2 Salary from EMP order by Salary desc

OR

select e1.sal from emp e1 where 2=(select count(distnct
(e2.sal) from emp e2 where e2.sal>=e1.sal)