sql——查重，去重

查重

SELECT
	count(1),
	profession
FROM
	st_profession
GROUP BY
	profession
HAVING
	count(1) > 1

表需要删除重复的记录（重复记录保留1条）

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

查找表中多余的重复记录，重复记录是根据单个字段

1 select * from  TB_MAT_BasicData1
2 where MATNR in ( select MATNR from  TB_MAT_BasicData1 group by MATNR having count(MATNR)>1)