求一个sql语句

原始表是
=====================
主机名    是否合规
A            Y
B            Y
C            N
D            UNKNOW
E            UNKNOW
======================


sql语句需要得到的结果：

==============
Y      40%
N      20%
UNKNOW  40%
==============

---

SQL code:
SELECT
是否合规 ,LTRIM(COUNT(*)*1.0/(SELECT COUNT(*) from TB))AS PER
from TB GROUP BY 是否合规

---

SQL code:
--> Title : Generating test data @TB
--> Author : wufeng4552
--> Date : 2009-11-13 15:35:02
declare @TB table (主机名 nvarchar(2),是否合规 nvarchar(12))
insert into @TB
select 'A','Y' union all
select 'B','Y' union all
select 'C','N' union all
select 'D','UNKNOW' union all
select 'E','UNKNOW'
select 是否合规,
ltrim(cast(count(*)*100.0/(select count(*) from @tb)as dec(18,2)))+'%'
from @tb group by 是否合规
/*
是否合规
------------ ------------------------------------------
N 20.00%
UNKNOW 40.00%