SQL删除所有重复数据。

初始化数据：

IF object_id('tempdb..#a') IS NOT NULL
                        BEGIN
                            DROP TABLE #a
                        END  
   Select '11' as A,'22' as B,'33' as C into  #a
   
   insert into #a values('11','22','33')
   insert into #a values('11','22','33')
   insert into #a values('44','55','66')
   insert into #a values('44','55','66')

   Select * From #a

处理逻辑：排重查询结果后，插入临时表，再清空原表，最后将临时表数据插入原表

IF object_id('tempdb..#b') IS NOT NULL
                        BEGIN
                            DROP TABLE #b
                        END  


Select distinct A,B,C into #b From #a


Delete From #a


--Select * into #a From #b


Insert Into #a Select * From #b


Select * from #a