sql
SELECT rpt.rpt_name ,COUNT(*) total,
CONCAT(CAST(CONVERT(100 * CAST(count(*) AS DECIMAL) / CAST((SELECT COUNT(*) FROM risk_place where rpc_id=32) AS DECIMAL), DECIMAL) AS CHAR) ,'%') AS percentage
FROM risk_place rp left join risk_place_type rpt on rp.rpt_id=rpt.rpt_id where rp.rpc_id=32 GROUP BY rp.rpt_id
结果