回答編集履歴

1

誤字修正

2023/10/11 16:10

投稿

hirohiro
hirohiro

スコア2068

test CHANGED
@@ -12,9 +12,9 @@
12
12
  (
13
13
  SELECT
14
14
  ( CASE
15
- WHEN T.col < 0 THEN T.col2
15
+ WHEN col < 0 THEN col2
16
- WHEN T.col > 100 THEN T.col3
16
+ WHEN col > 100 THEN col3
17
- ELSE T.col4
17
+ ELSE col4
18
18
  ) AS d,
19
19
  col5
20
20
  FROM TABLE