select convert(varchar(10),时间,120), ltrim(cast(sum(col)*100.0/(select sum(col) from tb) as dec(18,2)))+'%' from tb group by convert(varchar(10),时间,120)
select convert(varchar(10),时间,120), sum(col), (select sum(col) from tb), ltrim(cast(sum(col)*100.0/(select sum(col) from tb) as dec(18,2)))+'%' from tb group by convert(varchar(10),时间,120)
select 时间=convert(varchar(10),时间字段,120), 比例=convert(dec(18,4),数据字段*1.0/(select sum(数据字段) from tb) from tb --这样就OK了啊,不需要遍历啊。如果不是这样,请提供10行左右测试数据
convert(varchar(10),时间,120),
ltrim(cast(sum(col)*100.0/(select sum(col) from tb) as dec(18,2)))+'%'
from
tb
group by
convert(varchar(10),时间,120)
convert(varchar(10),时间,120),
sum(col),
(select sum(col) from tb),
ltrim(cast(sum(col)*100.0/(select sum(col) from tb) as dec(18,2)))+'%'
from
tb
group by
convert(varchar(10),时间,120)
select
时间=convert(varchar(10),时间字段,120),
比例=convert(dec(18,4),数据字段*1.0/(select sum(数据字段) from tb)
from tb
--这样就OK了啊,不需要遍历啊。如果不是这样,请提供10行左右测试数据