oracle常用sql集锦

发布时间：2021-02-24 16:11 所属栏目：128 来源：网络整理

导读：1、删除表中重复的数据只留下一条: DELETE from 表 WHERE (id) IN ( SELECT id FROM 表 GROUP BY id HAVING COUNT (id) 1 ) AND ROWID NOT IN ( SELECT MIN (ROWID) FROM 表 GROUP BY id HAVING COUNT ( * ) 1 );

1、删除表中重复的数据只留下一条:

DELETE from 表 WHERE (id) IN ( SELECT id FROM 表 GROUP BY id HAVING COUNT(id) > 1) AND ROWID NOT IN (SELECT MIN(ROWID) FROM 表 GROUP BY id HAVING COUNT(*) > 1);

（编辑：ASP站长网）