不知道是不是這樣:( SELECT shopno,SUM(quantity) AS Total_per, SUM(Quantity)/total_All AS [PERCENT] FROM TableName p CROSS JOIN (SELECT SUM(Quantity) as Total_all FROM TableName ) b GROUP BY shopno,total_all
select shopno,itemno,quantity,(100*quantity)/(select sum(quantity) from tablename T where t.itemno = tablename.itemno group by t.itemno) from tablename
select shopno,(100*SUM(quantity))/(select sum(quantity) from tablename) from tablename group by shopno
to xiaonan(无刃):我试了你的语句,真的是可以,太感谢了,佩服! 谢谢,我一定给分! 还有什么其它的方法吗?请大家发表意见,因为我觉得这种统计在日常中比较常用到,比如group by a,b,c 的时候,再统计a的总数占的百分比,b的总数占的百分比,c的总数占的百分比 ........欢迎讨论。
from tablename
group by shopno
SELECT shopno,SUM(quantity) AS Total_per, SUM(Quantity)/total_All AS [PERCENT]
FROM TableName p CROSS JOIN
(SELECT SUM(Quantity) as Total_all FROM TableName ) b
GROUP BY shopno,total_all
select shopno,itemno,quantity,
convert(varchar(4),quantity/(select sum(quantity) from tablename)*100)+'%'from tablename
我试了你的语句,可是不行啊, sql server提示句法不对.各位,帮忙啊。
from tablename
from tablename
group by shopno
还有什么其它的方法吗?请大家发表意见,因为我觉得这种统计在日常中比较常用到,比如group by a,b,c 的时候,再统计a的总数占的百分比,b的总数占的百分比,c的总数占的百分比 ........欢迎讨论。
xiaonan(无刃) 答非所问!
Yang_(扬帆破浪) 正确无误!
playyuer(小干部儿) 画蛇添足!