select
(lag(shou,1) over(order by id)+
lag(shou,2) over(order by id)+
lag(shou,3) over(order by id)+
lag(shou,4) over(order by id)+
lag(shou,5) over(order by id)+
lag(shou,6) over(order by id)+
lag(shou,7) over(order by id)+
lag(shou,8) over(order by id)+
lag(shou,9) over(order by id)+
lag(shou,10) over(order by id)+
lag(shou,11) over(order by id)+
lag(shou,12) over(order by id)+
lag(shou,13) over(order by id)+
lag(shou,14) over(order by id))/14,
* from bh
PGSQL计算14天均线
最新推荐文章于 2022-08-09 09:14:58 发布
该博客探讨了如何使用SQL的窗口函数计算指定列的滑动平均值，具体涉及lag()函数的连续应用，适用于数据趋势分析和统计计算场景。
扫一扫
4786
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
