回答編集履歴
1
編集
answer
CHANGED
|
@@ -2,7 +2,7 @@
|
|
|
2
2
|
最初に各商品IDの最新日付を取得してからJOINと言う形が一般的ですね。
|
|
3
3
|
|
|
4
4
|
```SQL
|
|
5
|
-
SELECT product_id, price, shop_id, modified FROM product p
|
|
5
|
+
SELECT p.product_id, p.price, p.shop_id, p.modified FROM product p
|
|
6
6
|
INNER JOIN (
|
|
7
7
|
SELECT product_id, MAX(modified) modified
|
|
8
8
|
FROM product
|