聚合函数理解

所有的聚合函数都是依照group by 去计算在组内中所有元素行

SELECT
"部门", toInt64(multiIf(isNull("最大数量"),0,"最大数量")) AS "最大数量","统计类型",'空格' AS "空格"
FROM
(          
SELECT
   "部门",toInt64(multiIf(isNull("最大数量"),0,"最大数量")) AS "最大数量" ,"统计类型",'空格' AS "空格"
  FROM
  (
 SELECT
 any("部门") AS "部门", max("最大数量") AS "最大数量",any("统计类型") AS "统计类型"
FROM (
SELECT "部门" ,sum("最大数量") AS "最大数量",'点击数最高部门（单位：次）' AS  "统计类型"
FROM
(
SELECT  dept_one AS "部门", name,fun_code,
                max((case
                        when(server_time >=today()) then
                         click_records
                        else
                           NULL
                      end
                     )) as "最大数量", 
                                '点击数最高部门' AS  "统计类型"
                                
                FROM
                (SELECT m.*, s.event_property_code,s.event_property_value FROM daily_new_clientrpt_master m LEFT JOIN daily_new_clientrpt_slave s on m.event_id= s.event_id  ORDER BY server_time DESC) T   WHERE  auth_type IN('2')   GROUP BY
                "部门" ,name,fun_code,"统计类型" ORDER BY "最大数量" DESC) GROUP BY "部门","统计类型" ORDER BY "最大数量" DESC)))