-
1.示例数据表
-
2.普通分组求和
select source , sum(amount) as sum from interest group by source
根据资金来源统计表interest中各项来款总额。
-
3.普通分组求和+综合统计
select coalesce(source,"合计") as source , sum(amount) as sum from interest group by source with rollup
根据资金来源统计表interest中各项来款总额,并且在最后一行输出合计值。
-
4.视图创建