2020-02-16 标签:世界杯,猜想,活动,各类,榜单,sql,语句,小结,增幅,降幅,排名,实现,代码,如下,select,top,50,username,sum

/*增幅降幅排名*/ 实现代码如下： Select top 50 UserName,sum(ReceivePrice) - sum(GuessPrice) as ReceivePrice, cast(sum(CASE WHEN ReceivePrice>0 THEN 1.0 ELSE 0 EN