/*MySql去重复的SQL*/
CREATE TABLE tmp AS SELECT
max(id) AS col1
FROM
tab
GROUP BY
tab.grp;
DELETE
FROM
tab
WHERE
id NOT IN (SELECT col1 FROM tmp);
DROP TABLE tmp;
/*通用的去重复办法*/
DELETE
FROM
<span style="white-space:pre"> </span>tab
WHERE
<span style="white-space:pre"> </span>id NOT IN (
<span style="white-space:pre"> </span>SELECT
<span style="white-space:pre"> </span>max(c.id)
<span style="white-space:pre"> </span>FROM
<span style="white-space:pre"> </span>tab c
<span style="white-space:pre"> </span>GROUP BY
<span style="white-space:pre"> </span>c.grp
<span style="white-space:pre"> </span>)