使用以下SQL语句:COUNT(QA.RequestID) AS QACount, CAST((COUNT(QA.RequestID)/COUNT(DISTINCT [User].Id)) AS DECIMAL(10,4)) AS PercentOf JOIN [QA] ON [User].Id = [QA].RequestId
WHERE QAStatus = 'Pink' GROUP BY [QA
我正在尝试查找满足特定条件的行的百分比。我的查询很接近,但答案总是四舍五入到最接近的整数。 例如,下面的查询返回6,但它应该返回6.25。这意味着6.25%的行满足该条件。我该怎么做呢? select sum(case when name like 'H%' then 1 else 0 end) * 100 / count(*)
from category