回答編集履歴
3
修正
answer
CHANGED
|
@@ -17,13 +17,12 @@
|
|
|
17
17
|
```
|
|
18
18
|
追記
|
|
19
19
|
---
|
|
20
|
-
質問の追記に対する追記
|
|
20
|
+
質問の追記に対する追記※修正
|
|
21
21
|
```SQL
|
|
22
22
|
select id into hoge
|
|
23
23
|
from hoge
|
|
24
|
-
where
|
|
24
|
+
where (
|
|
25
|
-
when '1' then ID='1'
|
|
26
|
-
|
|
25
|
+
(tmp='1' and ID='1') or (tmp='2' and ID in ('2','3'))
|
|
27
|
-
|
|
26
|
+
)
|
|
28
27
|
and name = 'name_1';
|
|
29
28
|
```
|
2
追記
answer
CHANGED
|
@@ -14,4 +14,16 @@
|
|
|
14
14
|
case when tmp='1' then '1'
|
|
15
15
|
when tmp='2' or tmp='3' then '2'
|
|
16
16
|
end
|
|
17
|
+
```
|
|
18
|
+
追記
|
|
19
|
+
---
|
|
20
|
+
質問の追記に対する追記
|
|
21
|
+
```SQL
|
|
22
|
+
select id into hoge
|
|
23
|
+
from hoge
|
|
24
|
+
where case tmp
|
|
25
|
+
when '1' then ID='1'
|
|
26
|
+
when '2' then ID in ('2','3')
|
|
27
|
+
end
|
|
28
|
+
and name = 'name_1';
|
|
17
29
|
```
|
1
推敲
answer
CHANGED
|
@@ -12,6 +12,6 @@
|
|
|
12
12
|
複数の条件も記述できます。
|
|
13
13
|
```SQL
|
|
14
14
|
case when tmp='1' then '1'
|
|
15
|
-
when tmp
|
|
15
|
+
when tmp='2' or tmp='3' then '2'
|
|
16
16
|
end
|
|
17
17
|
```
|