select Category,REPLACE(sum(Amount),'-','') as Amount
from T_Detail WHERE CREATED_BY='6123EC14-50E2-4D4A-AACA-6A9578AAFDBB'
group by Category
说明:Amount中的减号为支出标记,统计时去掉
select Category,REPLACE(sum(Amount),'-','') as Amount
from T_Detail WHERE CREATED_BY='6123EC14-50E2-4D4A-AACA-6A9578AAFDBB'
group by Category
说明:Amount中的减号为支出标记,统计时去掉
转载于:https://www.cnblogs.com/kangjing/p/3718680.html