17,377
社区成员
发帖
与我相关
我的任务
分享
select rownum rn,t.*
from (select
sum(d.coil),
sum(sum(d.coil))over(order by substr(to_char(d.cdate,'yyyymmdd'),1,6),d.jh) acc_coil,
sum(d.cwater),
sum(sum(d.cwater))over(order by substr(to_char(d.cdate,'yyyymmdd'),1,6),d.jh) acc_cwather,
-- sum(sum(d.cye))over(partition by substr(to_char(d.cdate,'yyyymmdd'),1,6)) acc_cye
sum(sum(d.cye))over(order by substr(to_char(d.cdate,'yyyymmdd'),1,6),d.jh) acc_cye
from t_01 d
group by substr(to_char(d.cdate,'yyyymmdd'),1,6),d.jh ) t
1:综合函水率 怎么算出来的?
2:为什么当“输入的时间条件是 2008-2”,结果出来的是2,3月份的数据? 过滤条件是 日期>= '2008-02'?
3:如果有采油井2,采油井3怎么办?
[Quote=引用 3 楼 y63964632 的回复:]最好说清楚字段值“生产时间(月) 产油量(月) 累积产油量 综合函水率 累积产水量 累积产液体量”是怎么算出来的
[Quote=引用楼主 y63964632 的帖子:]