MYSQL取表中分数排名前10%的学生信息
MYSQL取表中分数排名前10%的学生信息SELECT `name` FROM(select table.`name`, @row_num:=@row_num+1 as row_numfrom table, (SELECT @row_num:=1) as bORDER BY score DESC) new_tablewhere new_table.row_num<=@row_num*0.1;使用变量@row_num,先以score排序,然后添加排名列(@row_num:=@row_
原创
2021-06-16 16:51:44 ·
5388 阅读 ·
0 评论