MySQL 某列数据所占总和百分比 SQL实例
2021-05-24 10:05:17

SELECT a.address,a.cont AS countAddress,b.sum AS sumAddress,CONCAT( ROUND( a.cont / b.sum * 100, 2 ), '', '%' ) AS percent FROM( SELECT address, COUNT( address ) AS cont FROM person_base_info GROUP BY address ) a,(SELECT COUNT(*) AS sum FROM person_base_info ) b ......

本文摘自 ：https://www.cnblogs.com/