删除重复数据
delete
from <表名> t1
where ROWID!=(select max(ROWID) from <表名> t2 where t1.<唯一键> =t2.<唯一键> )
mybatis-xml 批量插入数据
insert into <表名> (id, name, time)
<foreach collection="entityList" separator="UNION ALL" item="entity">
select #{entity.id}, #{entity.name}, #{entity.time}
from dual
</foreach>