题解 | 出现三次以上相同积分的情况
出现三次以上相同积分的情况
https://www.nowcoder.com/practice/c69ac94335744480aa50646864b7f24d
select number FROM grade GROUP BY number --分组 HAVING COUNT(number)>=3 --筛选符合条件的组 聚合函数不能用在where中 ORDER BY number--
运行顺序FROM → GROUP BY → HAVING → SELECT → ORDER BY
字节跳动二面565人在聊