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(没意义)