zzjjzzgggg 发表于 2013-1-29 15:21:50

oracle数据去重

方法一：
 
delete
from pornpages t1
where t1.rowid>(select min(t2.rowid) from pornpages t2 where t1.recordid=t2.recordid)
 
 
方法二：
delete
from pornpages
where rowid not in(select min(rowid) from pornpages group by recordid)
 
推荐方法一
页: [1]
查看完整版本: oracle数据去重