在实际项目中,我们经常定义一列在全局中为唯一值 ,但是由于自己唯一值计算可能导致数据重复(没有使用唯一索引),我们该怎么判断某一列数据是否重复了呢?废话不多说,直接上sql。
sql语句
1、单一列判重 无重复
select guid from table1
group by guid having count(*)>1
2、单一列判重 有重复
select contract_no from table1
group by contract_no having count(*)>1
3、多列判重 无重复
select guid,contract_no from table1
group by guid,contract_no having count(*)>1
4、单一列 有重复 重复条数
select contract_no,count(1) as num from table1
group by contract_no having count(*)>1