SQL : top 2 salary in each department

select * from (
select dept,sal,row_number() over(partition by dept order by sal desc) as dd from emp
) as t where t.dd < 2