回答編集履歴
2
追記
test
CHANGED
|
@@ -6,22 +6,26 @@
|
|
|
6
6
|
|
|
7
7
|
```SQL
|
|
8
8
|
|
|
9
|
-
select ユーザーid, sum(購入金額)
|
|
9
|
+
select p.ユーザーid, u.名前, sum(p.購入金額)
|
|
10
10
|
|
|
11
11
|
from (
|
|
12
12
|
|
|
13
|
-
select *
|
|
13
|
+
select *
|
|
14
14
|
|
|
15
|
-
, row_number() over(partition by ユーザーid order by 購入id desc) as seq
|
|
15
|
+
, row_number() over(partition by ユーザーid order by 購入id desc) as seq
|
|
16
16
|
|
|
17
|
-
from 購入履歴テーブル
|
|
17
|
+
from 購入履歴テーブル
|
|
18
18
|
|
|
19
|
-
where ユーザーid in (・・・)
|
|
19
|
+
where ユーザーid in (・・・)
|
|
20
20
|
|
|
21
|
-
)
|
|
21
|
+
) p
|
|
22
22
|
|
|
23
|
-
|
|
23
|
+
inner join ユーザーテーブル u
|
|
24
24
|
|
|
25
|
+
on p.ユーザーid = u.ユーザーid
|
|
26
|
+
|
|
27
|
+
where p.seq <= 100
|
|
28
|
+
|
|
25
|
-
group by ユーザーid
|
|
29
|
+
group by p.ユーザーid, u.名前
|
|
26
30
|
|
|
27
31
|
```
|
1
追記
test
CHANGED
|
@@ -16,6 +16,8 @@
|
|
|
16
16
|
|
|
17
17
|
from 購入履歴テーブル
|
|
18
18
|
|
|
19
|
+
where ユーザーid in (・・・)
|
|
20
|
+
|
|
19
21
|
) t
|
|
20
22
|
|
|
21
23
|
where seq <= 100
|