62,041
社区成员
发帖
与我相关
我的任务
分享
var result = from r in dt_info.AsEnumerable()
group r by r.Field<string>(0) into g
select new { company = g.Select(R => R.Field<string>(0)),
C_Count = g.Select(R => R.Field<string>(1)).GroupBy(I => I).Count(),
c_c = g.Select(R => R.Field<string>(4)).GroupBy(I => I).Count() };
create table #Tmp
(
cn varchar(50),
num varchar(50),
pname varchar(50)
)
insert into #Tmp values('aa','001','x')
insert into #Tmp values('aa','001','y')
insert into #Tmp values('aa','005','y')
insert into #Tmp values('bb','002','x')
insert into #Tmp values('cc','003','x')
select cn,count(distinct(num)),COUNT(cn) as c
from #Tmp
group by cn
drop table #Tmp