如何在linq（vb.net）中編寫此查詢？ select B.Name from Company B group by B.Name having COUNT(1) > 1
2 回答
搖曳的薔薇
TA貢獻1793條經(jīng)驗 獲得超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
提交
取消