orcal删除相同数据
比如有以下数据:
需要根据code name删除相同数据,
delete from BB t
where t.rowid not in
(select max(rowid) from BB t1 group by t1.code,t1.name);
执行完再查询就只剩唯一一条了
比如有以下数据:
需要根据code name删除相同数据,
delete from BB t
where t.rowid not in
(select max(rowid) from BB t1 group by t1.code,t1.name);
执行完再查询就只剩唯一一条了