回答編集履歴

1

訂正

2023/04/21 03:07

投稿

sazi
sazi

スコア25199

test CHANGED
@@ -7,9 +7,9 @@
7
7
  , color
8
8
  , quantity
9
9
  )
10
- SELECT ID, name, color quantity
10
+ SELECT id, name, color quantity
11
11
  FROM tableA
12
12
  where id in (
13
- SELECT Min(ID) FROM tableA group by name, color
13
+ SELECT Min(id) FROM tableA group by name, color
14
14
  )
15
15
  ```