delete result from (select ROW_NUMBER() over(partition by qqqq order by qqqq)r,* from (select * from Table_1 where qqqq in (select qqqq from Table_1 where aaaa =12 group by qqqq having count(qqqq) > 1) and aaaa =12)t ) result where result.r!=1
sql删除重复数据保留一条 可以有多个条件 记录一下
最新推荐文章于 2023-01-08 00:06:19 发布