根据rowid删除重复数据
查询一下:
select *
from emp a
where rowid != (select max(rowid)
from emp b
where a.ename = b.ename
and.. .)
删除:
delete from emp a
where rowid != (select max(rowid)
from emp b
where a.ename = b.ename
and.. .)
根据rowid删除重复数据
查询一下:
select *
from emp a
where rowid != (select max(rowid)
from emp b
where a.ename = b.ename
and.. .)
删除:
delete from emp a
where rowid != (select max(rowid)
from emp b
where a.ename = b.ename
and.. .)
转载于:https://my.oschina.net/yZLZkvk6bjiN/blog/490299