84669 person learning
152542 person learning
20005 person learning
5487 person learning
7821 person learning
359900 person learning
3350 person learning
180660 person learning
48569 person learning
18603 person learning
40936 person learning
1549 person learning
1183 person learning
32909 person learning
欢迎选择我的课程，让我们一起见证您的进步~~
select hot,class from (select *from table order by hot desc) as a group by class
Class is deduplicated, only 2 lines are left?
The description is not very clear,This is what I understand:
SELECT `class` , COUNT(`hot`) as hot from `t` GROUP BY `class` ORDER BY `hot` DESC
I think it means taking the class that corresponds to the largest hot. Is this okay?
select max(hot) as hot ,class from table group by class;
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
select hot,class from (select *from table order by hot desc) as a group by classClass is deduplicated, only 2 lines are left?
The description is not very clear,
This is what I understand:
I think it means taking the class that corresponds to the largest hot. Is this okay?