查询数据占比

SELECT VQTY AS 次数,MenuName AS 菜单名称
,
cast( cast( (convert(decimal(10,2), m.VQTY)/convert(decimal(10,2), 777710))*100 as dec(18,2)) as varchar(10)) + '%' AS 比例
FROM
(

SELECT COUNT(1) AS VQTY,MenuName
FROM MenuVisitLog
WHERE VisitDate > DATEADD(MONTH,-1,GETDATE())
GROUP BY MenuName
) m
ORDER BY VQTY DESC

效果：

98809 课程排名 12.71%