sql删除重复记录

DELETE E FROM t E where E.id>

(
SELECT MIN(X.id)

FROM t X

WHERE X.name = E.name
);