27,580
社区成员
发帖
与我相关
我的任务
分享
select cast(10/2 as decimal(9,2))
--------------------------------------
5.00
--上面是求每款产品的合格率,以下是总合格率
create proc sp_test
as
select ltrim(cast(sum(up)*100.0/count(1) as dec(9,2)))+'%' as 合格率
from product
go
create proc sp_test
as
select name,ltrim(cast(sum(up)*100.0/count(1) as dec(9,2)))+'%' as 合格率
from product
group by name
go
create proc test
as
select sum(Up)/count(*)
from tb