問(wèn)題描述

問(wèn)題解答

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

class去重，就剩2行？

描述的不是很清楚,我理解的是這樣的:

SELECT `class` , COUNT(`hot`) as hot from `t` GROUP BY `class` ORDER BY `hot` DESC回答4：

我感覺意思就是取class對(duì)應(yīng)hot最大的。那這樣是否可以？

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