select COUNT(IDNumber),IDNumber from dbo.Child
group by IDNumber
having COUNT(IDNumber)>1
SQL筛选重复字段
最新推荐文章于 2023-11-29 18:31:17 发布
select COUNT(IDNumber),IDNumber from dbo.Child
group by IDNumber
having COUNT(IDNumber)>1