質問編集履歴
3
あ
test
CHANGED
File without changes
|
test
CHANGED
@@ -58,6 +58,8 @@
|
|
58
58
|
|
59
59
|
|
60
60
|
|
61
|
+
### 参考程度のSQLです。
|
62
|
+
|
61
63
|
```SQL
|
62
64
|
|
63
65
|
SELECT kind_id, COUNT(*) FROM sample WHERE fruits_id IN (1, 2) GROUP BY kind_id HAVING COUNT(*) = 2;
|
2
kind_id
test
CHANGED
File without changes
|
test
CHANGED
@@ -60,7 +60,7 @@
|
|
60
60
|
|
61
61
|
```SQL
|
62
62
|
|
63
|
-
SELECT
|
63
|
+
SELECT kind_id, COUNT(*) FROM sample WHERE fruits_id IN (1, 2) GROUP BY kind_id HAVING COUNT(*) = 2;
|
64
64
|
|
65
65
|
```
|
66
66
|
|
1
あ
test
CHANGED
File without changes
|
test
CHANGED
@@ -55,3 +55,15 @@
|
|
55
55
|
|
56
56
|
|
57
57
|
```
|
58
|
+
|
59
|
+
|
60
|
+
|
61
|
+
```SQL
|
62
|
+
|
63
|
+
SELECT col1, COUNT(*) FROM table1 WHERE col2 IN (1, 2) GROUP BY col1 HAVING COUNT(*) = 2;
|
64
|
+
|
65
|
+
```
|
66
|
+
|
67
|
+
|
68
|
+
|
69
|
+
上記も参考にしましたがこれでは動的にならないのでできませんでした。
|