需求:在分组统计的时候,显示每个分组所占的百分比
效果图:
实现代码:
SELECT
COUNT(1) rs ,100*round(COUNT(*)/SUM(COUNT(*)) OVER(),4)||'%'
FROM
TB_USER t
GROUP BY
t.AREA
ORDER BY
rs DESC
需求:在分组统计的时候,显示每个分组所占的百分比
效果图:
实现代码:
SELECT
COUNT(1) rs ,100*round(COUNT(*)/SUM(COUNT(*)) OVER(),4)||'%'
FROM
TB_USER t
GROUP BY
t.AREA
ORDER BY
rs DESC