问个关于SQL语句的问题, 很简单的, 属于抢分类型的, 来看看吧

[xxx_20_02]

有个表 结构如下

序号 车号 故障现象 维修日期 维修人

select 故障现象, count(故障现象) as 数量 from wx group by 故障现象
用上面的语句我可以得到每种故障现象出现的次数
但是我还想得到 每种故障现象出现的次数占总数的百分比,
我该怎么改这句SQL语句

[CSDNM]

select 故障现象, convert(numeric(10,2),count(故障现象))/(select count(*) from wx) as 百分比
from wx group by 故障现象

[given]

declare @total_count int
select @total_count=count(1) from wx
select 故障现象, count(故障现象)/@total_count as 数量 from wx group by 故障现象

[OpenVMS]

select 故障现象, count(故障现象)*100.0/(select count(故障现象) from wx) as 故障百分比
from wx group by 故障现象

[OpenVMS]

select 故障现象, count(故障现象) as 次数,count(故障现象)*100.0/(select count(故障现象) from wx) as 占全部故障百分比
from wx group by 故障现象

[j9988]

如果记录多得话，不如分两句写，效率高
declare @total int
select @total=count(故障现象) from wx

select 故障现象, count(故障现象)*100.0/@total as 故障百分比
from wx group by 故障现象