select Userid from DingDingUsers WHERE IsDeleted=0 --挑出DingDingUsers表的UserId
select Distinct(Userid) from DingDingUsers WHERE IsDeleted=0 --获取去重后的UserId
select * From DingDingUsers(表) Where IsDeleted=0(假删除字段) and Userid(去重字段) In (Select Userid(去重字段) From DingDingUsers(表) Group By Userid(去重字段) Having Count(*)>1) --获取DingDingUsers表中某个字段的重复数据
Sql获取表中某个字段的重复数据
最新推荐文章于 2023-07-22 17:50:26 发布