摘要：
select s_cid,max(case when num = 1 then zhangwuny else null end) as 账务年月1,max(case when num = 1 then i_xiaofeil else null end) as 消费量1,max(case when num = 1 then i_bencicm else null end) as 本次抄吗1,max(case when num = 1 then d_bencicbrq else null end) as 本次抄表日期1,max(case when num = 2 then zhangwun... 阅读全文