2014年2月24日
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 阅读全文
posted @ 2014-02-24 14:14 葬神 阅读(260) 评论(0) 推荐(0) 编辑