Mysql如何进行分组，并且让每一组的结果按照某个字段排序，并且获取每一组的第一个字段

select * from (select * from table_name order by id desc) h where h.catagory_id in(value1,value2,value3) group by h.catagoryselect * from (select * from table_name order b