sql365 行转列，同时根据公司编码带上公司名称

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#'
  group by t1.data_dataid

 

 

RPDATA2016 自定义表的存储

LSBZDW 公司名称