試著查詢從上個月倒數第二天到本月倒數第二天的資料，結果出錯了，怎么改
uj5u.com熱心網友回復：
貼文本內容上來，圖片不好看。uj5u.com熱心網友回復：
select rownum, t.*from (select to_char(SC_GROSSTIME, 'yyyy-mm-dd hh24:mi:ss'),
SC_TRACETIME,
sc_TruckNo,
sc_Qty db,
sc_NetQty,
sc_Qty,
sc_NetQty - sc_BatchQty jdwc,
decode(sc_Qty,
0,
null,
round((sc_NetQty - sc_Qty) / sc_Qty * 100, 3)) xdcl,
null yh,
null bz
from sc_data.sc_Weighting_tb
where SC_SHIPTYPENO = 'ZA'
{and SC_PRODUCTNAME between LAST_DAY(to_date({#val_P_YEAR#}||'-'||{#val_P_MONTH#}||'-1'||' 18:00:00', 'yyyy-mm-dd hh24:mi:ss')-1)-1
and LAST_DAY(to_date({#val_P_YEAR#}||'-'||{#val_P_MONTH#}||'-1'||' 18:00:00', 'yyyy-mm-dd hh24:mi:ss')-1) }
{ and SC_PRODUCTNAME ='#val_wl#' }) t
union all
select null,
'合計',
null,
null,
sum(db),
sum(sc_NetQty),
sum(sc_Qty),
sum(jdwc),
decode(sum(sc_Qty),
0,
null,
round(sum(jdwc) / sum(sc_Qty) * 100, 3)) xdcl,null,null
from (select SC_GROSSTIME,
SC_TRACETIME,
sc_TruckNo,
sc_Qty db,
sc_NetQty,
sc_Qty,
sc_NetQty - sc_Qty jdwc,
decode(sc_Qty,
0,
null,
round((sc_NetQty - sc_Qty) / sc_Qty * 100, 3)) xdcl,
null yh,
null bz
from sc_data.sc_Weighting_tb
where SC_SHIPTYPENO = 'ZA'
{and SC_PRODUCTNAME between LAST_DAY(to_date({#val_P_YEAR#}||'-'||{#val_P_MONTH#}||'-1'||' 18:00:00', 'yyyy-mm-dd hh24:mi:ss')-1)-1 and LAST_DAY(to_date({#val_P_YEAR#}||'-'||{#val_P_MONTH#}||'-1'||' 18:00:00', 'yyyy-mm-dd hh24:mi:ss')-1) }
{ and SC_PRODUCTNAME ='#val_wl'# }) t
uj5u.com熱心網友回復：
這是修改的陳述句轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/32948.html
標籤：基礎和管理