32rgl 发表于 2014-4-12 20:34:18

sql删除重复记录

DELETE E FROM t E where E.id>

(
SELECT MIN(X.id)

FROM t X

WHERE X.name = E.name
);


页: [1]
查看完整版本: sql删除重复记录