回答編集履歴
1
書式の改善
test
CHANGED
|
@@ -18,7 +18,7 @@
|
|
|
18
18
|
|
|
19
19
|
item_nameも含めたいときはGroup by name,item_nameとしましょう。)
|
|
20
20
|
|
|
21
|
-
```
|
|
21
|
+
```SQL
|
|
22
22
|
|
|
23
23
|
SELECT name, COUNT(*) from test GROUP BY name having count(*) >=2
|
|
24
24
|
|