原数据
id pipeId pipeName pree price down dGY dZY dAS dDY dTR
1 1 1#AD 1 22 1 1 3 1 3 1
2 2 2#AD 1 12 2 1 3 1 3 1
3 2 2#AD 2 21 3 1 3 1 3 1
4 4 4#AD 1 12 4 1 3 1 3 1
5 5 5#AD 1 23 5 1 3 1 3 1
1. with rollup统计使用
select pipeName,SUM(pree) as pree,SUM(dGY) dGY,SUM(dAS),SUM(dZY) from pipe_c GROUP BY pipeName with rollup;
pipeName pree dGY SUM(dAS) SUM(dZY)
1# 1 1 1 1
2# 1 2 1 3
3# 2 1 1 1
4# 1 1 1 1
5# 1 2 1 1
6 7 5 7
2.with rollup统计下, COALESCE展示统计合计名称
select COALESCE(pipeName,'合计') as pipeName,SUM(pree) as pree,SUM(dGY) dGY,SUM(dAS),SUM(dZY) from pipe_c GROUP