1 List<Test> t = new List<Test>() { 2 new Test(){id=1,name="车辆"}, 3 new Test(){id=2,name="车辆"}, 4 new Test(){id=3,name="飞机"}, 5 new Test(){id=4,name="火车"}, 6 new Test(){id=4,name="火车"}, 7 }; 8 //同名 9 var q = t.GroupBy(x => x.name).Where(x => x.Count() > 1).ToList();10 11 foreach (var item in q)12 {13 Console.WriteLine(item.Key);14 }
sql:
1 --重复的物品编码2 SELECT COUNT(0) AS num,Code3 FROM dbo.Goods 4 GROUP BY Code5 HAVING COUNT(0)>16 ORDER BY Code
0条大神的评论