回答編集履歴
2
訂正
test
CHANGED
|
@@ -6,7 +6,7 @@
|
|
|
6
6
|
|
|
7
7
|
from (
|
|
8
8
|
|
|
9
|
-
select *, row_number() over(partition by 顧客番号 order by 最新 desc) as seq
|
|
9
|
+
select *, row_number() over(partition by 顧客番号, 番号 order by 最新 desc) as seq
|
|
10
10
|
|
|
11
11
|
from card
|
|
12
12
|
|
1
訂正
test
CHANGED
|
@@ -8,6 +8,8 @@
|
|
|
8
8
|
|
|
9
9
|
select *, row_number() over(partition by 顧客番号 order by 最新 desc) as seq
|
|
10
10
|
|
|
11
|
+
from card
|
|
12
|
+
|
|
11
13
|
) t1
|
|
12
14
|
|
|
13
15
|
where seq=1
|