delete from table1
 where rowid not in (select max(rowid) from table1 group by 所有字段)

------解决方案--------------------
SQL code
delete from table1
 where rowid not in (select max(rowid) from table1 group by 所有字段)

------解决方案--------------------
2、3楼的正解，修改如下：
delete from 表名
  where rowid not in (select max(rowid) from 表名
  group by 员工标识,社会关系,姓名,年龄)

------解决方案--------------------
探讨

通过 rowid 来区分相同数据的记录行

SQL code
delete from table1
 where rowid not in (select max(rowid) from table1 group by 所有字段)


------解决方案--------------------
delete from table1 a
where a.rowid<>(select max(rowid) from table1 b where a.主键=b.主键)

delete from table1
where rowid not in (select max(rowid) from table1 group by 所有字段)

学习了

------解决方案--------------------
探讨

通过 rowid 来区分相同数据的记录行


SQL code
delete from table1
 where rowid not in (select max(rowid) from table1 group by 所有字段)


------解决方案--------------------
SQL code
delete from table1
 where rowid not in (select max(rowid) from table1 group by 所有字段)

------解决方案--------------------
探讨

SQL code

delete from table1
 where rowid not in (select max(rowid) from table1 group by 所有字段)
正解


------解决方案--------------------
rowid速度最优