当前位置:Gxlcms > mysql > MYSQL排行类的相关SQL写法,仅供参考_MySQL

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

时间:2021-07-01 10:21:17 帮助过:4人阅读

bitsCN.com
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
bitsCN.com

人气教程排行