SQL 检测是否存在相同的行。

不说废话，直接上语句！

SELECT batt_no,COUNT(1) FROM dbo.CODE003
GROUP BY batt_no HAVING COUNT(1)>1

 

SELECT moto_no,COUNT(1) FROM dbo.CODE003
GROUP BY moto_no HAVING COUNT(1)>1

 

SELECT fram_no ,COUNT(1) FROM dbo.CODE003
GROUP BY fram_no HAVING COUNT(1)>1

 

SELECT charger_no ,COUNT(1) FROM dbo.CODE003
GROUP BY charger_no HAVING COUNT(1)>1