查询表中某字段有重复记录个数

1
2
3
select id,count(id) from @table
GROUP BY id
having count(id)>1
坚持原创技术分享,您的支持将鼓励我继续创作!