sql - 在 SQL 中如何使用 COUNT 转换为百分比？

Question

例如，如果我想在“员工”表中列出男性和女性的百分比。这样对吗？

SELECT Sex, COUNT (Sex) AS [%]
FROM Employees
GROUP BY Sex;

如果我想列出少于 50% 的性别怎么办？以下是正确的吗？

SELECT Sex, COUNT (Sex) AS [%]
FROM Employees
GROUP BY Sex
HAVING COUNT (Sex) < 50%

谢谢。

Answer 1

我相信这就是您要找的。

SELECT Sex, (Count(Sex)* 100 / (SELECT Count(*) FROM Employees)) as MyPercentage
FROM Employees
GROUP BY Sex

然后你可以做

HAVING MyPercentage < 50