数据表
sql
select @rownum:=@rownum+1,student.*
from (select @rownum:=0) t1 ,
(select * from student order by student.grade desc) student ##排序
where @rownum<(select round(count(*)/4) from student)
结果
数据表
sql
select @rownum:=@rownum+1,student.*
from (select @rownum:=0) t1 ,
(select * from student order by student.grade desc) student ##排序
where @rownum<(select round(count(*)/4) from student)
结果