select player_id,event_date,num as games_played_so_far
from (
select player_id,event_date,
case -- case end之间 when一个条件then条件满足后执行的语句
when @player=player_id then @num:=@num+games_played -- =比较 :=赋值
when @player:=player_id then @num:=games_played -- 条件一不满足执行条件2
end as num
from(
select *
from activity
order by player_id,event_date
) t1,
(
select @player=0,@num=0 -- 设置两个变量的初值,合并结果集到activity表中
)t2
)t3
mysql分支语句
最新推荐文章于 2024-08-04 19:39:35 发布