百度的时候查到的博客：
http://blog.csdn.net/xsfqh/article/details/6663895
-----------------------------------------------------------------------------------------------------------------------
其中内容：
给查询出的SQL记录添加序号列，解决方法有以下两种
第一：
select ROW_NUMBER() OVER (ORDER BY a.字段 ASC) AS XUHAO,a.* from table a
(table 为表名，字段为表a中的字段名)
第二：
select RANK() OVER (ORDER BY a.字段 ASC) AS XUHAO,a.* from table a(table 为表名，字段为表a中的字段名)
-----------------------------------------------------------------------------------------------------------------------
在需要获取最高分数从而获取排序的写法：
select ROW_NUMBER() OVER (ORDER BY Max(BearPickGold012Play.Score) DESC) AS xuhao,Max(BearPickGold012Play.Score) as Score,WeixinUserID from BearPickGold012Play where ActivitySceneID=1 GROUP BY WeixinUserID
select Rank() OVER (ORDER BY Max(BearPickGold012Play.Score) DESC) AS xuhao,Max(BearPickGold012Play.Score) as Score,WeixinUserID from BearPickGold012Play where ActivitySceneID=1 GROUP BY WeixinUserID