mysql 按分组不同给前20或者17进行积分，第一名20第二名递减1分

SET @rownum:=17; – 注意：“：=”表示赋值，“=”表示比较，“@”表示变量
SET @rownum1:=20;
/两个积分值，一个为17，一个为20/

SELECT
/packid 为不同的类型编码/
(CASE WHEN packid =7187 THEN ( CASE WHEN @rownum-1 > 0 THEN @rownum:=@rownum-1 WHEN @rownum-1 < 0 THEN " " END ) WHEN packid =7188 THEN ( CASE WHEN @rownum1-1 > 0 THEN @rownum1:=@rownum1-1 WHEN @rownum1-1 < 0 THEN " " END ) END ) AS jifen1,
/每符合条件的类型从多到少进行积分减一/
a.*
FROM
(
SELECT

game_packages.id as packid,
signups.game_id,
players.no,
players.time_used
FROM
signups

INNER JOIN game_packages on signups.pack_id = game_packages.id

WHERE
signups.game_id = 2142
and players.status=300
)
as a
ORDER BY time_used asc