我需要这个 Rank 查询也有一个 IF 语句来计算输赢并将百分比放在@percentage
变量中。我不知道如何将排名查询与百分比查询相结合。
mysql_query("SELECT name, wins, losses, level, xp, @curRank := @curRank + 1 AS rank
FROM teams p, (SELECT @curRank := 0) r
WHERE `console` = 3 AND `game` = 23 AND `laddertype` = 1
ORDER BY xp DESC");
选择名称,赢,输,级别,经验值,胜为W,输为L,截断(赢/IF(赢=0,1,胜+输)*100,0)作为PCT,@curRank := @curRank + 1作为团队P的排名,(选择@curRank:= 0)R,其中console
= 3,game
= 23,laddertype
= 1 按XP顺序;