質問編集履歴
2
WHERE句の修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -39,8 +39,8 @@
|
|
39
39
|
WHEN a.mx = 3 THEN CONCAT(a.item1, " ", a.item2, " ", a.item3)
|
40
40
|
ELSE NULL END AS all_items
|
41
41
|
FROM a) b
|
42
|
-
WHERE b.all_items LIKE '%
|
42
|
+
WHERE b.all_items LIKE '%222%'
|
43
|
-
AND b.all_items LIKE '%
|
43
|
+
AND b.all_items LIKE '%333%'
|
44
44
|
GROUP BY b.t_id;
|
45
45
|
```
|
46
46
|
|
1
誤字の修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -13,7 +13,7 @@
|
|
13
13
|
|3|2|333|peach|
|
14
14
|
|3|3|444|grape|
|
15
15
|
|
16
|
-
orangeとpeachの組合せ
|
16
|
+
orangeとpeachの組合せを含むt_idを抽出条件とし、これに該当するt_id個別件数を取得する方法として、
|
17
17
|
|
18
18
|
```SQL
|
19
19
|
/*sampleテーブルを横持ち変換*/
|