回答編集履歴
1
不要なWHEREを削除
answer
CHANGED
|
@@ -24,7 +24,6 @@
|
|
|
24
24
|
WHEN [カラム名] = 3 THEN '銅'
|
|
25
25
|
END award
|
|
26
26
|
FROM [テーブル名]
|
|
27
|
-
WHERE [カラム名] IN (1, 2, 3)
|
|
28
27
|
) TMP
|
|
29
28
|
WHERE award IS NOT NULL
|
|
30
29
|
|