Delete duplicate records

delete from emp where id in(
select id from (
Select id, sal,dense_rank() over (partition by sal order by id) as den
from emp
) t where t.den >1
)