:-)with deldup as(select_rownumber()over(partition by(empide) group by(empid)

))as da from emp wher 1=1

delete from deldup where da>1