Mysql--GROUP BY xxxx WITH ROLLUP用法

GROUP BY xxxx WITH ROLLUP

– GROUP BY xxxx WITH ROLLUP 是为了算出所有聚合函数的总结果

SELECT day FROM dim_5g_cell_info GROUP BY day;
SELECT day FROM dim_5g_cell_info GROUP BY day WITH ROLLUP;
SELECT day,SUM(ant_engine_angle) FROM dim_5g_cell_info GROUP BY day;
SELECT coalesce(day, ‘总计’),day,SUM(ant_engine_angle) FROM dim_5g_cell_info GROUP BY day WITH ROLLUP;

coalesce(day, ‘总计’) day SUM(ant_engine_angle)
20200228 20200228 177179.7
20200320 20200320 142967.7
20201027 20201027 361470.7
总计 NULL 681618.1000000001

Tips:
参数说明
coalesce(a,b,c)：
如果a == null,则选择b；
如果b == null,则选择c；
如果a!=null,则选择a；
如果a b c 都为null ，则返回为null（没意义）