美文网首页
2023-02-17 删除重复数据

2023-02-17 删除重复数据

作者: 1f658716b568 | 来源:发表于2023-02-16 10:49 被阅读0次
    select * from His_4251022 group by ID having count(*)>1;
    
    
    delete from His_4251022 where His_4251022.rowid not in (select MAX(His_4251022.rowid) from His_4251022 group by ID);
    

    相关文章

      网友评论

          本文标题:2023-02-17 删除重复数据

          本文链接:https://www.haomeiwen.com/subject/lerpkdtx.html