mysql查询总成绩的前3名学生信息

mysql 8.0+版本

使用窗口函数

mysql8.0下

select  id,STATUS,@rank1 :=@rank1+1,@rank :=
case when @popularity = status then @rank
when @popularity := status then @rank1 END as rank 
from s_working_confition_file_info,
(select @rank :=0,@popularity :=NULL,@rank1 :=0) init 
ORDER BY status DESC;