如何在linq(vb.net)中编写此查询? select B.Name from Company B group by B.Name having COUNT(1) > 1
2 回答
摇曳的蔷薇
TA贡献1793条经验 获得超6个赞
像这样:
from c in db.Company
group c by c.Name into grp
where grp.Count() > 1
select grp.Key
或者,使用方法语法:
Company
.GroupBy(c => c.Name)
.Where(grp => grp.Count() > 1)
.Select(grp => grp.Key);
添加回答
举报
0/150
提交
取消