如何使用帆软可以添加时间这个字段名,时间这个字段名为a.time,在 V_REPORT_CCM表中体现的
select aa,bb from
(select count(a.HEAT_ID) aa from V_REPORT_CCM a where a.CCM='1'
and a.ESP='0'
and a.TIME between trunc(to_date('${date}','yyyy-MM'),'mm')+3600*8/86400
and
trunc(add_months(to_date('${enddate}','yyyy-MM'),1),'mm')+3600*8/86400
) a,
(select count(a.HEAT_ID) bb from V_REPORT_CCM a where a.HEAT_ID in (select DISTINCT B.SAMPLEID from PSS.QCM_C_CHE_STEEL b where b.C_g='01'
and
b.sampletype like 'D3%'
and a.CCM='1'
and a.ESP='0'
and
a.TIME between trunc(to_date('${date}','yyyy-MM'),'mm')+3600*8/86400
AND
trunc(add_months (to_date('${enddate}','yyyy-MM'),1),'mm')+3600*8/86400
)) b |