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

Question

想要达到的效果是先按hot从高到底排序，再把class字段去重，最后输出数据。试过distinct,group,都不行。请教下大神们。

大家讲道理 · Answer

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

ringa_lee · Answer

class去重，就剩2行？

PHP中文网 · Answer

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

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

伊谢尔伦 · Answer

我覺得意思就是拿class對應hot最大的。那這樣是否可以？

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

php8，我來也