mysql过滤重复项留下最新项 

SELECT
    *
FROM
    carregisterinfo a
WHERE
    (a.plate) IN (
        SELECT
            plate
        FROM
            carregisterinfo
        GROUP BY
            plate
        HAVING
            count(*) >= 1
    )
AND id  IN (
    SELECT
        max(id)
    FROM
        carregisterinfo
    GROUP BY
        plate
    HAVING
        count(*) >= 1
)

 原表数据如下：

 

posted @ 2021-01-12 09:08  Smah  阅读(169)  评论(0)  编辑  收藏  举报