SELECT CONCAT(CONVERT(COUNT(DISTINCT a)*100/COUNT(DISTINCT b),DECIMAL(18,2)),'%') AS [百分比] FROM 表名
CONCAT('a/b','%')代表拼接%
decimal(18, 2) 代表截取两位位小数
SELECT CONCAT(CONVERT(COUNT(DISTINCT a)*100/COUNT(DISTINCT b),DECIMAL(18,2)),'%') AS [百分比] FROM 表名
CONCAT('a/b','%')代表拼接%
decimal(18, 2) 代表截取两位位小数