Question

求助Linq问题，查处重复数据

把重复的数据查出来，下面是自己的的sql，执行是可以的，想再程序里转成linq，要怎么写，求大神帮忙
select * from Articles where Title in(Select Title From Articles Group By title Having Count(*) > 1) order by title
如果有更好的linq写法也可以自由发挥

Answer 1

from t in Articles where
(from t1 in Articles group t1 by t1.Title into groupT
where groupT.Count()>1 select groupT.Key).Contains(t.Title) orderby t.Title
select t

Answer 2

var titles = db.Tables.GroupBy(q=>q.Title).Where(s=>s.Count()>1).Select(q=>q.Title);
var result=db.Tables.Where(q=> titles.Contains(q.Tilte)).OrderBy(q=>q.Title);