select COUNT(IDNumber),IDNumber from dbo.Child
group by IDNumber
having COUNT(IDNumber)>1
SQL筛选重复字段
最新推荐文章于 2023-12-14 15:26:22 发布
select COUNT(IDNumber),IDNumber from dbo.Child
group by IDNumber
having COUNT(IDNumber)>1