查询数据占比

2024-01-23 17:10:10

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