以一下博主的文章为起点:
1.http://blog.csdn.net/babyfish13/article/details/54313682
2.http://blog.csdn.net/u010503822/article/details/52538028
排名和计算差值,会使用的mysql的变量@,使用方式
set @var := 1;
select @var := 0;结果是0
select里面每一次设置值+1,其实就是使用mysql的变量来处理
select s.*,@last_score,@last_score - s.`score`,@last_score :=s.`score`,@rank := @rank+1 as rank from `score` s,(select @rank :=0) t order by `score` desc