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博客 ” ,链接:http://blog.itpub.net/23135684/viewspace-668269/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23135684/viewspace-668269/