ORACLE 去除重复记录
摘要：delete from tbl_talbe where (col1,col2,col3) in (select col1,col2,col3 from tbl_table group by col1,col2,col3having count(*)>1) and rowid not in ( select max(rowid) from tbl_table group by col1,col2,col3 having count(*) >1 )
阅读全文
posted @ 2010-02-09 16:07
