<span style="font-family: Arial, Helvetica, sans-serif;">网上搜集的一段排名sql 列出排名</span>
SELECT A.*,@rank:=@rank+1 as pm
FROM
(
SELECT startscore as AvgS FROM mm_user_pet ORDER BY startscore
) A ,(SELECT @rank:=0) B;
返回排序的结果和startscore 。。