在MySQL的选择查询中，使用CASE，WHEN，THEN，END结束
||
我正在与棒球相关的网站上工作。我有一张桌子，上面有两个棒球队的击球阵容：
+----+----------+--------------+--------+
| id | playerId | battingOrder | active |
+----+----------+--------------+--------+
SELECT *
FROM lineups
WHERE battingOrder =
CASE (
SELECT battingOrder
FROM lineups
WHERE battingOrder > 10 AND active = 1
LIMIT 1
)
WHEN 11 THEN 12
WHEN 12 THEN 13
WHEN 13 THEN 14
WHEN 14 THEN 15
WHEN 15 THEN 16
WHEN 16 THEN 17
WHEN 17 THEN 18
WHEN 18 THEN 19
WHEN 19 THEN 11
END
LIMIT 1;
没有找到相关结果
已邀请:
1 个回复
俺呵誓放胳
Select LNext.player As NextPlayer From lineups As L Left Join lineups As LNext On LNext.BattingOrder Between 11 And 20 And LNext.BattingOrder = Case When L.BattingOrder = 19 Then 11 Else L.BattingOrder + 1 End Where L.battingOrder Between 11 And 20 And L.active = 1Select LNext.player As NextPlayer From lineups As L Left Join lineups As LNext On LNext.BattingOrder = Case When L.BattingOrder = 19 Then 11 When L.BattingOrder = 9 Then 1 Else L.BattingOrder + 1 End Where L.active = 1