1、获取定义重复记录的字段,例如name字段;
2、获取表中唯一标识记录的字段,例如objectid字段;
3、执行下列语句:
delete from table a where a.objectid not in (select max(objectid) from table b group by b.name)
1、获取定义重复记录的字段,例如name字段;
2、获取表中唯一标识记录的字段,例如objectid字段;
3、执行下列语句:
delete from table a where a.objectid not in (select max(objectid) from table b group by b.name)