更新时间:2022-11-13 16:10:17
with x as (select *,rn = row_number()
over(PARTITION BY OrderNo,item order by OrderNo)
from #temp1)
select * from x
where rn > 1
您可以通过将 select 语句替换为
you can remove duplicates by replacing select statement by
delete x where rn > 1