oracle分组求和并求百分比
1个回答
展开全部
WITH t1 AS(
SELECT 'a' c1, 2 c2 FROM dual
UNION ALL SELECT 'a' c1, 4 c2 FROM dual
UNION ALL SELECT 'b' c1, 1 c2 FROM dual
UNION ALL SELECT 'b' c1, 8 c2 FROM dual
)
SELECT c1, SUM(c2), SUM(c2)/(SELECT SUM(c2) FROM t1) FROM t1 GROUP BY c1
SELECT 'a' c1, 2 c2 FROM dual
UNION ALL SELECT 'a' c1, 4 c2 FROM dual
UNION ALL SELECT 'b' c1, 1 c2 FROM dual
UNION ALL SELECT 'b' c1, 8 c2 FROM dual
)
SELECT c1, SUM(c2), SUM(c2)/(SELECT SUM(c2) FROM t1) FROM t1 GROUP BY c1
本回答被网友采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
