質問するログイン新規登録

回答編集履歴

1

推敲

2020/03/12 09:58

投稿

sazi
sazi

スコア25430

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::timestamp
44
+ on msr.scale @> tst.idx_date
45
45
  ) step1
46
46
  where scale_seq=1 --1件に絞る
47
47
  ```