关於.net LINQ分组查询使用方法 使用VB语言完成
发布网友
共1个回答
热心网友
C# 版的
var datatable = new[] {
new {name = "aa", num = 5},
new {name = "aa", num = 6},
new {name = "aa", num = 11},
new {name = "ab", num = 1},
new {name = "ab", num = 8},
};
var result = datatable.GroupBy(o => o.name).Select(o => new { name = o.Key, num = (datatable.Where(p => p.name == o.Key).Select(r => r.num).Max() - datatable.Where(q => q.name == o.Key).Select(x => x.num).Min()) });
理解含义，用VB写一样的
