oracle删除表中重复数据
假设现在有表lefta? 字段id，name
DELETE FROM lefta bWHERE NOT EXISTS(SELECT 1FROM(SELECT a.rowid,a.*,row_number() OVER (PARTITION BY ID ,NAME ORDER BY ID) num FROM lefta a)WHERE num<=1AND ROWID = b.ROWID)1 楼 lee20101029 2010-12-27 这个写得蛮好的，看得出你数据库技术不错，希望有空可以多多交流。
