sql - MySQL，在分组前排序

Question

如果我发出这样的查询:

select c1, c2, c3
from table
group by c1;

我得到了 c1 的不同结果，但我如何在分组依据之前对其进行排序(例如 c2 降序)？

Answer 1

select c1, c2, c3 
from (select c1, c2, c3 from table order by c2 desc) t 
group by c1;