SELECT [ID], COUNT(*) AS 重复数量 FROM [TABLE] GROUP BY [ID] HAVING (COUNT(*) > 1)
查看重复记录
最新推荐文章于 2023-03-13 18:59:40 发布
SELECT [ID], COUNT(*) AS 重复数量 FROM [TABLE] GROUP BY [ID] HAVING (COUNT(*) > 1)