declare @a int select @a=(select count(*) from mb where e=1 and f=2 and g=3 group by e,f,g)
declare @b int select @b=(select count(*) from mb where e=4 group by e)
declare @c decimal(4,2)
--这里
select @c=@a*1.00/@b
-------------------------------
select @c
declare @b int select @b=(select count(*) from mb where e=4 group by e)
declare @c decimal(4,2)
--这里
select @c=@a*1.00/@b
-------------------------------
select @c
或者写成:
select @c=@a*1.00/@b
declare @b int select @b=11
declare @c decimal(4,2) ,@d decimal(4,2) select @c=@a/@b ,@d = @a*1.0/@b select @c ,@d
--------------------------------------- ---------------------------------------
0.00 0.73
declare @b int select @b=(select count(*) from mb where e=4 group by e) *1.00
declare @c decimal(4,2) select @c=@a/@b select @c
declare @b dec(4,2)select @b=(select count(*) from mb where e=4 group by e) *1.00
declare @c decimal(4,2) select @c=@a/@b select @c modify