删除重复记录并且只保留一条

SELECT *
FROM
    zy_agent_money_history
WHERE
    id NOT IN (
SELECT
            amh.minid
FROM
            (
SELECT MIN(id) AS minid
FROM
                    zy_agent_money_history
GROUP BY
                    agent_id,orgin_id, TYPE,create_time,amount,balance,remarks
            ) amh
    )  AND type=3