MySQL 重复数据的简单处理方式

SELECT
    a.id,
    a.XH,
    a.XZBH,
    a.BYF,
    COUNT(1) AS c
FROM
    `t_sdrs_xsxj` AS a
GROUP BY
    XH
HAVING
    c > 1;

SELECT * FROM t_sdrs_xsjbxx ORDER BY xh;

SELECT DISTINCT xh,XM,XB FROM v_xs_jbxx;

DELETE FROM user
    WHERE id NOT IN (
        SELECT temp.min_id FROM (
            SELECT MIN(id) min_id FROM user
                GROUP BY name,age
            )AS temp
    );