1、分組之后再合計

關鍵字： grouping sets （（分組字段1，分組字段2），（））

select sylbdm ,count(sylbmc) as rs,round(count(sylbmc)/(select count(sylbmc) from bmk),4)*100 || '%' as bl
from bmk 
GROUP BY grouping sets ((sylbdm ),())

2、顯示不為空的值

關鍵字： coalesce合并多個字段，顯示第一個不為null的值

        select COALESCE(sylbdm, '合計')                                          as lx,count(sylbdm)                                                     as rs,ROUND(COUNT(sylbdm) / (select count(*) from BMK) * 100, 2) || '%' AS blfrom BMKgroup by GROUPING SETS ((sylbdm), ())