select 字段2, sum(1/count(字段1)) from Table1 group by 字段2这样行不行?
create table #T( a varchar(10) null, b varchar(10) null )goinsert into #T values ('a','李') insert into #T values ('a', '梁') insert into #T values ('b', '王') insert into #T values ('c', '李') insert into #T values ('d', '周') insert into #T values ('e', '王')select #T.b, sum(iCount) from #T inner join (select a, [iCount]=1.0/count(*) from #T group by a ) z on #T.a=z.a group by #T.bdrop table #T
select convert(float,count(*))/2 from YouTable group by 字段2
Select 字段2,次数=Sum(次数) from (Select a.字段2,a.字段21,Cast((1/(tmp.次数+0.00)) as decimal(8,2)) as 次数 from (Select 字段1,次数=Count(*) from 表 Group by 字段1)tmp,表 a where tmp.字段1=a.字段1)B Group by 字段2
from Table1
group by 字段2这样行不行?
a varchar(10) null,
b varchar(10) null
)goinsert into #T values ('a','李')
insert into #T values ('a', '梁')
insert into #T values ('b', '王')
insert into #T values ('c', '李')
insert into #T values ('d', '周')
insert into #T values ('e', '王')select #T.b, sum(iCount)
from #T inner join (select a, [iCount]=1.0/count(*)
from #T
group by a
) z on #T.a=z.a
group by #T.bdrop table #T
Select 字段2,次数=Sum(次数) from (Select a.字段2,a.字段21,Cast((1/(tmp.次数+0.00)) as decimal(8,2)) as 次数
from (Select 字段1,次数=Count(*) from 表 Group by 字段1)tmp,表 a where tmp.字段1=a.字段1)B Group by 字段2