回答編集履歴
1
Dを忘れていた
test
CHANGED
|
@@ -27,6 +27,7 @@
|
|
|
27
27
|
WHEN 'A' IN (TAG1,TAG2,TAG3) THEN 1
|
|
28
28
|
WHEN 'B' IN (TAG1,TAG2,TAG3) THEN 2
|
|
29
29
|
WHEN 'C' IN (TAG1,TAG2,TAG3) THEN 3
|
|
30
|
+
WHEN 'D' IN (TAG1,TAG2,TAG3) THEN 4
|
|
30
31
|
ELSE 0
|
|
31
32
|
END RANK
|
|
32
33
|
, T.*
|