mysql - 这里的sql语句该怎么写

Answer 1

select hot,class from (select *from table order by hot desc) as a group by class

Answer 2

class去重，就剩2行？

Answer 3

描述的不是很清楚,
我理解的是这样的:

SELECT `class` , COUNT(`hot`) as hot from `t` GROUP BY `class` ORDER BY `hot` DESC

Answer 4

我感觉意思就是取class对应hot最大的。那这样是否可以？

 select max(hot) as hot ,class from table  group by class;