53
小白求教： mysql 怎么实现排序后新增一列并分区段赋值，比如分数排名前 20%的就是绩...
source link: https://www.v2ex.com/t/567720
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
MySQL - @ditie - 比如数据表 kaohe 的字段有 id，department,date，userid，score。需求有三个：1、怎么根据 score 在一个语句里分月度、分部门进行组内排序，以及当月全体
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK