--1select sum(case when flag=1 then 1 else 0 end)*1./count(*) from tb--2select name,sum(case when flag=1 then 1 else 0 end)*1./count(*) from tb group by name
select 100.0*sum(case when flag = 1 then 1 else 0 end)/count(1) as 百分比 from a
select count(1)/(select count(1) flags from tb ) from tb where flag = 1
--1select ltrim(cast(sum(case when flag=1 then 1 else 0 end)*100./count(*) as decimal(12,2))) + '%' from tb--2select name,ltrim(cast(sum(case when flag=1 then 1 else 0 end)*100./count(*) as decimal(12,2))) + '%' from tb group by name
select name,ltrim(cast(sum(case when flag=1 then 1 else 0 end)*100./count(*) as decimal(12,2))) + '%' as 百分比 from tb group by name
--1select sum(case when flag=1 then 1 else 0 end)*1./count(*)
from tb--2select name,sum(case when flag=1 then 1 else 0 end)*1./count(*)
from tb
group by name
from a
--1select ltrim(cast(sum(case when flag=1 then 1 else 0 end)*100./count(*) as decimal(12,2))) + '%'
from tb--2select name,ltrim(cast(sum(case when flag=1 then 1 else 0 end)*100./count(*) as decimal(12,2))) + '%'
from tb
group by name
name,ltrim(cast(sum(case when flag=1 then 1 else 0 end)*100./count(*) as decimal(12,2))) + '%' as 百分比
from
tb
group by
name