Oracle去除表中重复值(只留一条数据)
DELETE FROM text t WHERE t.rowid NOT IN (SELECT MAX(rowid) FROM text t1 GROUP BY t1.phoneNumber)
t1.phoneNumber :去重的字段
DELETE FROM text t WHERE t.rowid NOT IN (SELECT MAX(rowid) FROM text t1 GROUP BY t1.phoneNumber)
t1.phoneNumber :去重的字段