1、先来看一张表TMP的数据(无主键)
查询重复记录数
语句:
SELECT Station,City,Temperature,COUNT(*)重复记录数
FROM TMP
GROUP BY Station,City,Temperature
HAVING COUNT(*)>1
结果:
说明没有重复记录
2、再来看另一张表TMP1的数据(无主键)
查询重复记录数
语句:
SELECT Station,City,Temperature,COUNT(*)重复记录数
FROM TMP1
GROUP BY Station, City, Temperature
HAVING COUNT(*)>1
结果: