删除sql表中重复数据
摘要：
1.select identity(int,1,1) as autoID, * into #Tmp from tablename2.select min(autoID) as autoID into #Tmp2 from #Tmp group by 字段1,字段23.select * into #Tmp3 from (select * from #Tmp where autoID in(select autoID from #tmp2)) t 阅读全文
posted @ 2012-12-15 13:25 天亦玄 阅读(143) 评论(0) 推荐(0)
浙公网安备 33010602011771号