SQL> select * from test_rowid;
ID NAME
---------- ----------------------------------------------------------------------------------------------------
111 aaa
222 bb
3333 cccc
333 bb
222 bb
111 aaa
111 aaa
7 rows selected.
SQL> delete from test_rowid a where a.rowid!=(select max(b.rowid) from test_rowid b where a.id=b.id and a.name=b.name);
3 rows deleted.
SQL> select * from test_rowid;
ID NAME
---------- ----------------------------------------------------------------------------------------------------
3333 cccc
333 bb
222 bb
111 aaa
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23135684/viewspace-668269/ ，如需转载，请注明出处，否则将追究法律责任。
