If you using merge solution given by "Jason-299789 " then duplicate data will not going to come

and if you want to delete duplicate record from same table

then use simple row_number,or using distinct

you can delete data

like

delete from

(

select a,row_number() over (partition by a order by a) as srno,b

from @temptable

) c

where srno>1