可以这样得到正确的数据:
select PT_ID,deode(FE_TYPE,'A','家电','n','器具','C','衣服','D','其他',FE_TYPE) ,sum(COSTS)
from MR_COSTS
group by PT_ID,deode(FE_TYPE,'A','家电','n','器具','C','衣服','D','其他',FE_TYPE) ;
select PT_ID,deode(FE_TYPE,'A','家电','B','器具','C','衣服','D','其他',FE_TYPE) ,sum(COSTS)
from MR_COSTS
group by PT_ID,deode(FE_TYPE,'A','家电','B','器具','C','衣服','D','其他',FE_TYPE) ;