8,497
社区成员
发帖
与我相关
我的任务
分享
var result = from x in Table1
join temp in
(
from dt in Table1
group dt by dt.Name into g
where g.Count() > 1
select new { g.Key, ID = g.Max(y => y.ID) }
)
on x.ID equals temp.ID
select x;
var result = from x in Table1
join temp in
(
from dt in Table1
group dt by dt.Name into g
where g.Count() > 1
select new { g.Key, ID = g.Max(y => y.ID) }
)
on x.DocAccountID equals temp.ID
select x;
var result = from x in Table
group x by x.Name into g
select (from y in g orderby y.ID descending select y).First();
其实sql写不好,那么linq表达式也写不好。反之,如果linq写不好,那么你的sql也好不到哪里去。