select 机构号,Convert(DECIMAL(10,2),SUM(结欠金额)/10000) as 支出余额,count(DISTINCT(证件号码)) as 支出户数,COUNT(证件号码) as 支出笔数,
Convert(DECIMAL(10,2),SUM(结欠金额)/10000/count(DISTINCT(证件号码))) as 户均支出金额
from dk
where 结欠金额>0 and 客户类型=3
GROUP BY 机构号
Convert(DECIMAL(10,2),SUM(结欠金额)/10000/count(DISTINCT(证件号码))) as 户均支出金额
from dk
where 结欠金额>0 and 客户类型=3
GROUP BY 机构号
sql统计查询结果汇总行怎么写 ? 还要得到什么 你具体说下
select 机构号,Convert(DECIMAL(10,2),SUM(结欠金额)/10000) as 支出余额,count(DISTINCT(证件号码)) as 支出户数,COUNT(证件号码) as 支出笔数,
Convert(DECIMAL(10,2),SUM(结欠金额)/10000/count(DISTINCT(证件号码))) as 户均支出金额
from dk
where 结欠金额>0 and 客户类型=3
GROUP BY 机构号 with rollup
UNIOIN ALL
SELECT SUM(机构号),SUM(支出余额),SUM(支出户数),SUM(户均支出金额) FROM 上面的table但是 SUM(户均支出金额) 有什么意义呢?