沙发
- 经验值 0
| - F豆 3617 个
| - F币 1 元
- 贡献 0
| - 最后登录 2021-5-19
发表于 2012-3-7 09:34:56
--N日均线 , n-1为参数
select rownum,t1.fdate,t1.s_close,avg(t1.s_close) over(partition by t1.s_number1 order by t1.fdate asc rows between 4 preceding and 0 preceding) as rkhhh from test.stock_01 t1 order by t1.fdate
|
|