sql语句
CONCAT(CAST(CONVERT(100 * CAST(count(*) AS DECIMAL) / CAST((SELECT COUNT(*) FROM thy_ams.host_endpoint) AS DECIMAL), DECIMAL) AS CHAR) ,'%') AS percentage
//CONCAT 合并连个字段
//CAST 转换字符类型
示例
SELECT *,COUNT(e.id) total,
CONCAT(CAST(CONVERT(100 * CAST(count(*) AS DECIMAL) / CAST((SELECT COUNT(*) FROM thy_ams.host_endpoint) AS DECIMAL), DECIMAL) AS CHAR) ,'%') AS percentage
FROM thy_rdb.node AS node
INNER JOIN thy_ams.host_endpoint AS e
ON node.id = e.node_id
GROUP BY e.node_id
结果