Linq with group by having count

by

Like this:

from c in db.Company
group c by c.Name into grp
where grp.Count() > 1
select grp.Key

Or, using the method syntax:

Company
    .GroupBy(c => c.Name)
    .Where(grp => grp.Count() > 1)
    .Select(grp => grp.Key);

More Related Contents:

  1. SQL query for finding records where count > 1
  2. C# LINQ find duplicates in List
  3. What are the benefits of a Deferred Execution in LINQ?
  4. LINQ with groupby and count
  5. LINQ Partition List into Lists of 8 members [duplicate]
  6. LINQ Between Operator
  7. LINQ OrderBy versus ThenBy
  8. LINQ: combining join and group by
  9. What’s the difference between IQueryable and IEnumerable [duplicate]
  10. Can LINQ be used in PowerShell?
  11. Linq order by, group by and order by each group?
  12. Use LINQ to concatenate multiple rows into single row (CSV property)
  13. Linq-to-entities – Include() method not loading
  14. PowerShell equivalent of LINQ Any()?
  15. Instantiating a context in LINQ to Entities
  16. conditional include in linq to entities?
  17. LINQ not updating on .SubmitChanges()
  18. Linq To Entities – how to filter on child entities
  19. Expose IQueryable Over WCF Service
  20. The specified type member ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties
  21. Entity Framework, Code First and Full Text Search
  22. Conditional SQL count
  23. Simple Linq query has duplicated join against same table?
  24. LINQ Include vs Join. Are they equivalent?
  25. Tradeoffs using NHibernate 3.0 QueryOver or LINQ provider
  26. If condition in LINQ Where clause
  27. Point connectionstring in dbml to app.config
  28. Building Dynamic LINQ Queries based on Combobox Value
  29. Count number of records returned by group by
  30. NHibernate vs LINQ to SQL

Leave a Comment