摘要： 方法一： delete from employee where rowid not in (select max(t1.rowid) from employee t1 group by t1.emp_id,t1.emp_name,t1.salary); 解析：任何记录的ROWID只有一个值，在数据库里面是唯一的，select max(t1.rowid) from employee t1 grou... 阅读全文