组。计数重点领域的
问题描述:
select
count(di.field1) as myCount,
di.field2
from di
group by di.field2
我试着去理解这个概念:组。计数重点领域的
group di.field2 by new { di.field1, di.field2 } into g
select new
{
documentID = g.Key.field2,
docCount = g.Count(????)
});
我如何获得的价值FIELD1算?
答
也许是这样的:
group di by di.field2 into g
select new
{
documentID = g.Key,
docCount = g.Select(c => c.field1).Count()
});
答
您是否需要进行分组以获得字段数?你就不能这样做:
var count=di.field1.Count;
+0
都能跟得上...我需要FIELD1遭遇的数有相同的字段2 – 2013-02-19 17:59:50
答
from p in di
group p by p.field2 into g
select new { field2 = g.Key, field2Count = g.Count() };
检查这,这应该工作
不...我真的不能访问我的任何礼节 – 2013-02-19 18:07:13
?以及我做的,但从来没有错那么少。我更新了答案 – 2013-02-19 18:13:36
请发布初始化'di'的代码,也许这是问题的来源 – 2013-02-19 18:18:09