sqlserver百分数,sql server 计算百分比

sqlserver 里怎么求百分比

select REALHANDLER, count(*) as 总数, sum(case when status='RESOLVED' then 1 else 0 end)as 已解决,

sum(case when status!='RESOLVED' then 1 else 0 end)as 未解决,

sum(case when status='RESOLVED' then 1 else 0 end)+0.0001/count(*) as 完成率

from INCIDENT

group by REALHANDLER

)+0.0001试一下 因为返回的类型和sum(case when status='RESOLVED' then 1 else 0 end)，count(*) 一样

相关问答

Q1: Sqlserver求百分数的函数是什么，怎么用

在C1输入公式=text(round(A1/b1,4),"0.00%")，回车即可得出C1的结果。C2、C3步骤与之相同。

这里text函数用来将括号内的值转换为%形式；round函数用来四舍五入商的值。

Q2: SQLServer中如何查出数据库中百分比的数据

sql2005以后.优先使用如下方式，扩展性强。

---------------------------------------------------------------------

select A.* from

(

SELECT ROW_NUMBER() OVER(ORDER BY ID DESC) AS rownum ,B.*

FROM dbo.testB

) A

where A.rownum=1 and A.rownum=(select count(*)*3/10 from dbo.test)

---------------------------------------------------------------------

2000 数据库

SELECT TOP (select count(*)*3/10 from dbo.test) * FROM test order by ID DESC

----------------------------------------------------------

Q3: sqlserver 2000怎么计算累计百分比

--sql 2000

declare @tb table(row int identity(1,1),故障总成件 varchar(100),数量 int,占比 float)

insert into @tb select * from tb

select 故障总成件,数量,占比,累计百分比=(select sum(占比) from @tb t2 where t2.row=t1.row) from @tb t1

--sql 2005

with tc as(

select row=row_number()over(order by getdate()),* from tb

),

cte as(

select *,累计百分比=cast(占比 as decimal(28,3)) from tc where row=1 union all

select t.row,t.故障总成件,t.数量,t.占比,cast(c.累计百分比+t.占比 as decimal(28,3)) from tc t join cte c on t.row=c.row+1

)

select * from cte