查询案件表中每种案件的占比
使用CONVERT函数只保留统计结果的2位小数
CONVERT( 数字 , DECIMAL(10,2) )
SELECT
case_type AS '类型',
CONVERT( (COUNT(1)/(SELECT COUNT(1) FROM case_report WHERE is_delete = 0)*100), DECIMAL(10,2) ) AS '占比'
FROM
case_report
WHERE
is_delete = 0
GROUP BY
case_type
查询结果