Java mysql 删除重复的数据

select *
FROM
    game
WHERE
    name IN (
        SELECT
            t.name
        FROM
            (
                SELECT
                    name
                FROM
                    game
                GROUP BY
                    name
                HAVING
                    count(1) > 1
            ) t
    )
AND id NOT IN (
SELECT
    dt.idtmp
FROM
    (
        SELECT
            min(id) AS idtmp
        FROM
            game
        GROUP BY
            name
        HAVING
            count(1) > 1
    ) dt
);