1 查找表中多余的重復記錄，重復記錄是根據單個字段
1 select * from TB_MAT_BasicData1 2 where MATNR in ( select MATNR from TB_MAT_BasicData1 group by MATNR having count(MATNR)>1)

2.表需要刪除重復的記錄（重復記錄保留1條），

select distinct * into #Tmp from TB_MAT_BasicData1 drop table TB_MAT_BasicData1 select * into TB_MAT_BasicData1 from #Tmp drop table #Tmp

?

3.查詢重復 select count(1),UnitsofmeasureGuid from TB_MAT_UnitsOfMeasure group by UnitsofmeasureGuid having count(1)>1

?

轉載于:https://www.cnblogs.com/dqh123/p/10069351.html

總結

以上是生活随笔為你收集整理的SQL重复记录查询的几种方法的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。