回答編集履歴

1

SQL文の修正

2021/10/06 11:59

投稿

mayu-
mayu-

スコア335

test CHANGED
@@ -28,7 +28,7 @@
28
28
 
29
29
  , size_id
30
30
 
31
- HAVING count(1) > 1
31
+ HAVING count( distinct item_id ) > 1
32
32
 
33
33
  )
34
34
 
@@ -60,7 +60,7 @@
60
60
 
61
61
  , size_id
62
62
 
63
- HAVING count(1) > 1
63
+ HAVING count( distinct item_id ) > 1
64
64
 
65
65
  ) y
66
66