select t.*
from
(
select a.*
from table_1
where column_1 = "conditions"
order by column_2 desc,column_3 asc
) as t
group by column_4
order by column_5 desc
sql是这样的: select t.* from ( select a.* from table_1 where column_1 = "conditions" order by column_2 desc,column_3 asc ) as t group by column_4 order by column_5 desc 然后,这里要group by,而且要在group by之前要order by一次,不然,分组后拿不到各分组想要的那一条数据。现在问题来了~~~Subquery这货不支持o