94SY

SELECT First(Content.[Id]) AS [Id 字段], Count(Content.[Id]) AS NumberOfDups

FROM Content

GROUP BY Content.[Id]

HAVING (((Count(Content.[Id]))>1));

Content是表名

Id是字段

运行一下可以找到重复了几次