分析函数向前推自然日期方法

凝望长空

分析函数向前推自然日期方法

1. numtoyminterval  月
   
2. numdsinterval    日
   
3. 
   
4. select f0045_004v,
   
5.        f0045_001d,
   
6.        count(*) over(partition by f0045_004v order by f0045_001d asc range between numtoyminterval(1, 'month') preceding and current row) c
   
7.   from tb_trade_0045
   
8. where f0045_001d > sysdate - 100
   
9. order by 1, 2 desc

复制代码

星期六的深夜68

谢谢分享