8,497
社区成员
发帖
与我相关
我的任务
分享
var result =( from a in Table
group a by a.memberid into g
orderby g.Count() descending
select new
{
MemberId =g.Key,
Count=g.Count()
}).Take(3);
var query=db.MemberLog.GroupBy(m=>m.MemberId).OrderByDescending(g=>g.Count()).Select(g=>g.First()).Take(3);