Delete Duplicate Keys

最新推荐文章于 2024-11-13 10:09:56 发布

Adventure1995

最新推荐文章于 2024-11-13 10:09:56 发布

阅读量119

点赞数

分类专栏： SQL 文章标签： sql mysql

本文链接：https://blog.csdn.net/qq_25527791/article/details/113941112

版权

SQL 专栏收录该内容

9 篇文章 1 订阅

订阅专栏

delete from kjt_pay
where ORDERNO in (
  select T3.ORDERNO
  from (select
          T.ORDERNO,
          count(1)
        from kjt_pay T
        group by T.ORDERNO
        having count(1) > 1) T3
) and GUID not in (select T4.max_id
                   from (
                          select
                            max(T5.GUID) max_id,
                            count(1)
                          from kjt_pay T5
                          group by T5.ORDERNO
                          having count(1) > 1
                        ) T4);