MS SQL SERVER คำสั่งลบแถวซ้ำ

    select distinct * into #tmp From EmpDup
    delete from EmpDup
    insert into EmpDup                
    select * from #tmp drop table #tmp