删除重复记录

一、如果两行记录完全相同

select distinct * from employees;

二、如果记录除id，其他相同，可能是录入记录有误，如果要保持重复记录最小的id;

delete from employees where in not in

(select min_id from 

(select min(id) min_id from employees group by name) temp);