SELECT [ID], COUNT(*) AS 重复数量 FROM [TABLE] GROUP BY [ID] HAVING (COUNT(*) > 1)
查看重复记录
最新推荐文章于 2021-04-17 14:48:03 发布
SELECT [ID], COUNT(*) AS 重复数量 FROM [TABLE] GROUP BY [ID] HAVING (COUNT(*) > 1)