从数据表中查询数据进行统计,排行榜
SELECT * FROM (
SELECT a.*,
(@rowNum:=@rowNum+1) AS rank FROM vip_info AS a,
(SELECT (@rowNum :=0)
) b
ORDER BY a.startCount DESC,a.joinVipTime ASC
) vipInfo WHERE vipInfo.id=1
其中 rank 是名次,此sql是查询会员id为 1 ,rank 是会员id 为 1 的名次
从数据表中查询数据进行统计,排行榜
SELECT * FROM (
SELECT a.*,
(@rowNum:=@rowNum+1) AS rank FROM vip_info AS a,
(SELECT (@rowNum :=0)
) b
ORDER BY a.startCount DESC,a.joinVipTime ASC
) vipInfo WHERE vipInfo.id=1