联合唯一去重的SQL

一个能够对数据库进行联合唯一去重的SQL

delete from cve where id not in (select * from ((select min(id) from cve group by bug_number,versions,module_name)) tmp)
posted @ 2019-12-31 17:18  久末丶  阅读(353)  评论(0编辑  收藏  举报