MYSQL 排行类的相关SQL写法,仅供参考

SELECT * FROM
    (SELECT pid, (@rowno:=@rowno+1) as rowno FROM user, (select (@rowno:=0)) b WHERE cid = 1  order by total_score DESC) as c WHERE pid = 1