MYSQL 5.7实现ROW_NUMBER() 功能

序号展示功能

select (@i :=  @i + 1) as sortnum,
        a.id, a.name, a.student_number, a.address
    from student a, (select @i := 0) sortTable
    where a.is_delete = 0
    order by a.student_number asc

分组排序功能

select rn, id, name, student_number, score, subject
from (
select (@i := case when @student_number_copy = student_number then @i + 1 else 1 end) as rn,
@student_number_copy := student_number,
s.id, s.name, s.student_number, s.score, s.subject
from student_score s, (select @i = 0, @student_number_copy = 0) sortTable
order by student_number ASC, score desc) temp_table;