摘要:
Oracle:删除数据库中重复记录select corpname,count(*) from tbcorp group by corpname having count(*) > 1delete from tbcorp a where a.rowid!=(select min(b.rowid) from tbcorp b where a.corpname = b.corpname) 阅读全文
posted @ 2006-03-29 23:56 享受人生 阅读(682) 评论(1) 推荐(0)
浙公网安备 33010602011771号