示例代码如下：
create table tmp as select min(主键) as col1 from 去重表名 GROUP BY 去重字段;delete from 去重表名 where 主键 not in (select col1 from tmp); drop table tmp;
本文共 147 字，大约阅读时间需要 1 分钟。
示例代码如下：
create table tmp as select min(主键) as col1 from 去重表名 GROUP BY 去重字段;delete from 去重表名 where 主键 not in (select col1 from tmp); drop table tmp;
转载地址：http://nvuqa.baihongyu.com/