select distinct owner, table_name from test_sort2 order by owner,table_name;
建立一个所以再OWNER ,TABLE_NAME
这样可以避免排序
select owner, table_name
from test_sort2 a
where A.ROWID = (select /*+ no_unnest */ max(rowid)
from test_sort2 b
where a.owner = b.owner
and a.table_name = b.table_name)
order by owner,table_name;
删除重复的行
SQL> select * from oo;
IT
---------------------------------------
1
1
2
2
SQL>
SQL> delete oo a where a.rowid <> (select max(rowid)
2 from oo b
3 where a.it = b.it);
2 rows deleted
SQL> commit;
Commit complete
SQL> select * from oo;
IT
---------------------------------------
1
2
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7728585/viewspace-745223/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7728585/viewspace-745223/