方法一
delete d where rowid in (select rowid from(select * from (select deptno ,(row_number() over(partition by deptno order by deptno))no from d) where no >1)d);
方法二
delete d where rowid not in (select min(rowid) from d group by deptno);
delete d where rowid in (select rowid from(select * from (select deptno ,(row_number() over(partition by deptno order by deptno))no from d) where no >1)d);
方法二
delete d where rowid not in (select min(rowid) from d group by deptno);
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/27181165/viewspace-775847/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
打印“方阵”
下一篇：
oracle开机自启动
请登录后发表评论
登录
全部评论
