select t1.data_dataid, (select lsbzdw_dwmc from LSBZDW where lsbzdw_dwbh = t1.data_dataid), sum(decode(t1.data_kjqj, '01', t1.data_data)) as "1月",
sum(decode(t1.data_kjqj, '02', t1.data_data)) as "2月",
sum(decode(t1.data_kjqj, '03', t1.data_data)) as "3月",
sum(decode(t1.data_kjqj, '04', t1.data_data)) as "4月"
from RPDATA2016 t1 where data_hord = '0000042#' and data_lord = '0004#' and data_dataid in (select lsbzdw_dwbh from LSBZDW t2 where lsbzdw_dwmc like '%模糊搜索关键字%')
group by t1.data_dataid
写入sql
select t1.data_dataid, (select lsbzdw_dwmc from LSBZDW where lsbzdw_dwbh = t1.data_dataid), sum(decode(t1.data_kjqj, '01', t1.data_data)) as "1月", sum(decode(t1.data_kjqj, '02', t1.data_data)) as "2月", sum(decode(t1.data_kjqj, '03', t1.data_data)) as "3月", sum(decode(t1.data_kjqj, '04', t1.data_data)) as "4月" from RPDATA2016 t1 where data_hord = '0000042#' and data_lord = '0004#' and data_dataid in (select lsbzdw_dwbh from LSBZDW t2 where lsbzdw_dwmc like '%'||'<!V_dwmc!>'||'%') group by t1.data_dataid