1. 统计一个月内所有井的总产量数据
select jh,to_char(v.jssj,'yyyy-mm') as jssj,sum(pfdjrcyl),
sum(pfdjrcyl1),sum(pfdjrcyld),sum(hsl)from V_005_11_PRODUCTIONREPORT_CN v
group by to_char(v.jssj,'yyyy-mm') ,v.jh
1. 统计一个月内所有井的总产量数据
select jh,to_char(v.jssj,'yyyy-mm') as jssj,sum(pfdjrcyl),
sum(pfdjrcyl1),sum(pfdjrcyld),sum(hsl)