根据成绩排名

select t1.*,(@b:=@b+1) sort  from 

(select  t.sid,t.sname,t.grade from  tb_student t  order by grade desc) t1,(select @b:=0) b

select t1.*,(@b:=@b+1) as 别名

 from (排完续的结果) t1,  (select @b:=0) b