回答編集履歴
1
推敲
answer
CHANGED
@@ -41,7 +41,7 @@
|
|
41
41
|
, row_number() over(partition by msr.scale order by tst.idx_date) as scale_seq
|
42
42
|
from measure msr
|
43
43
|
left join test_table tst
|
44
|
-
on msr.scale @> tst.idx_date
|
44
|
+
on msr.scale @> tst.idx_date
|
45
45
|
) step1
|
46
46
|
where scale_seq=1 --1件に絞る
|
47
47
|
```
|