学亮编程手记

摘要： select (select name from t_area where id=areaid) 区域, sum(case when month = '01' then money else 0 end) 一月, sum(case when month = '02' then money else 0 end) 二月, sum(case when month = '... 阅读全文