select coalesce(create_by, 'allcount') as 'id',count(*) from sys_log where request_uri like '%iops/opsInfo/getCount' or request_uri like '%/appNotify/notify/getReadCount' or request_uri like '/sys/user/getMenus' GROUP BY create_by WITH ROLLUP
coalesce(a,b,c);
参数说明:如果anull,则选择b;如果bnull,则选择c;如果a!=null,则选择a;如果a b c 都为null ,则返回为null(没意义)。
效果图