質問編集履歴
1
データ不足
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -4,14 +4,18 @@
|
|
|
4
4
|
|
|
5
5
|
table=a
|
|
6
6
|
|
|
7
|
-
sale_date discout_price
|
|
7
|
+
ID sale_date discout_price
|
|
8
|
-
20181102 2390
|
|
8
|
+
1 20181102 2390
|
|
9
|
-
20181102 510
|
|
9
|
+
1 20181102 510
|
|
10
|
-
20171022 5280
|
|
10
|
+
1 20171022 5280
|
|
11
|
-
20160404 4608
|
|
11
|
+
2 20160404 4608
|
|
12
|
+
2 20181012 2200
|
|
12
13
|
|
|
14
|
+
→この場合だと
|
|
13
|
-
|
|
15
|
+
①IDは1 sale_dateは20181102 discount_priceは2390+510=2900
|
|
16
|
+
②IDは2 sale_dateは20181012 discount_priceは2200
|
|
14
17
|
|
|
18
|
+
|
|
15
19
|
### 試したこと
|
|
16
20
|
|
|
17
21
|
SELECT max(sale_date),discount_price FROM a
|