如何在sql中计算% [英] How to Calculate % in sql
本文介绍了如何在sql中计算%的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
总CustID
200 1
800 2
500 3
i想要仅使用Sql命令来计算每个Cust Id的百分比。
解决方案
所以也许类似
SELECT a.CustId,
(a.Total / b.AbsoluteFinalTotal)* 100
FROM MyTable a,
( SELECT SUM(总计) AS AbsoluteFinalTotal
FROM MyTable)b;
< blockquote>
选择总计,(总计* 100 /(选择 sum(总计)从 MyTable)) as 得分
来自 MyTable
小组 按总计
Total CustID
200 1
800 2
500 3
i want to calulate % of each Cust Id using Sql command only.
解决方案
So perhaps something like
SELECT a.CustId, (a.Total / b.AbsoluteFinalTotal) * 100 FROM MyTable a, (SELECT SUM(Total) AS AbsoluteFinalTotal FROM MyTable) b;
Select Total, (Total* 100 / (Select sum(Total) From MyTable)) as Score From MyTable Group By Total
这篇关于如何在sql中计算%的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文