sql分组取最大值

SELECT
    aa.*
FROM
    a_user aa
WHERE
    version = (
        SELECT
            max(version)
        FROM
            a_user
        WHERE
            type = aa.type
    )
ORDER BY
    aa.type desc