22,210
社区成员
发帖
与我相关
我的任务
分享
select chargedate,sum((case when detail = '物管费' then amount end)) as 物管费金额,
sum((case when detail = '二次加压费' then amount end)) as 二次加压费金额,
sum(case when detail='水池清洗费' then amount end) as 水池清洗费金额,
sum(case when detail='生活垃圾处置费' then amount end) as 生活垃圾处置费金额
from chargetable where fangxiang='收' and chargetype= '物管类费用' group by chargedate