1.
declare @db1Count money
select @db1Count=sum(投资额) from tblCount
2.cast(cast(字段 as decimal(5,4))*100 as varchar)+'%'
3.round(字段,4)
declare @db1Count money
select @db1Count=sum(投资额) from tblCount
2.cast(cast(字段 as decimal(5,4))*100 as varchar)+'%'
3.round(字段,4)
我想将select sum(投资额) from tblCount 的合计值赋给变量@dblCount,这样效率回高一点?如何赋值呀。
declare @a int
(select @a=sum(投资额) from tblCount)
select 项目,投资额,投资额/@a 比率 from tblCount问题二:
如何将比率字段显示成33.33%,
select 项目,投资额,cast(cast(投资额*1.0/@a as numeric(10,2)) as varchar(10))+'%' 比率 from tblCount
问题三:
如何对投资额字段四舍五入,
select 项目,cast(投资额 as numeric(10,2)),cast(cast(投资额*1.0/@a as numeric(10,2)) as varchar(10))+'%' 比率 from tblCount
declare @合计 decimal(10,2)
select @合计=sum(投资额) from tblCount2。3。
select 项目,round(投资额,0),left(cast((投资额/@合计)*100 as varchar),4)+'%' 比率 from tblCount