SELECT cityName, COUNT(*)
FROM city
GROUP BY cityName
HAVING COUNT(*) > 1
检查整个表是否存在重复数据.net
最新推荐文章于 2022-07-06 22:31:54 发布
SELECT cityName, COUNT(*)
FROM city
GROUP BY cityName
HAVING COUNT(*) > 1