1.根据条件去除未更新过的数据
select rowid, e.*
from t_employee e
where exists (select 1
from t_employee ee
where ee.idcard = e.idcard
and e.create_time < ee.create_time);
2.根据条件判定一致的数据,根据rowid删除rowid小的数据
注:根据rowid删除无法判断数据的新旧程度,有很大的随机性
select rowid, e.*
from t_employee e
where rowid <
(select max(rowid) from t_employee ee where ee.idcard = e.idcard);