用于计算游戏积分的sql

作者: 无思
发布时间: 2024-12-23 08:02:01 (1月前)
转自：

2 条回复

0#
回复此人
易米烊光 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 你可以用它来做 <code> UNION </code> ： </p> <pre> <code> SELECT team, SUM(points) AS total_points FROM ( SELECT team_home AS team, CASE WHEN team_home_goals > team_away_goals THEN 3 WHEN team_home_goals = team_away_goals THEN 1 ELSE 0 END AS points FROM games UNION ALL SELECT team_away AS team, CASE WHEN team_away_goals > team_home_goals THEN 3 WHEN team_away_goals = team_home_goals THEN 1 ELSE 0 END AS points FROM games ) AS t GROUP BY team ORDER BY total_points DESC </code> </pre> <P> <a href="http://sqlfiddle.com/#!9/726a5/3" rel="nofollow"> 的<strong> 在这里演示 </强> </A> </p> </DIV>

编辑

登录后才能参与评论