mysql 先排序后分组再排序查询数据

SELECT * FROM (SELECT * FROM table ORDER BY test DESC) AS a GROUP BY a.test1 ORDER BY a.test DESC;