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 心笑峰 阅读(178) 评论(0) 推荐(0) 编辑
