title: Using LINQ to get all the records in a table having the same value in a specific column
body: <p>I am trying to get all the rows in a table having the same value in a column. I got it working by using group by:</p>
  
  <pre><code>var groupedData = from row in Tab1Model.ExcelGridDataSource.AsEnumerable()
                                              group row by row.Field&lt;string&gt;("A");
  
  
          foreach (var group in groupedData)
          {
              if (group.Count() &gt; 1)
              {
                                      //select from each group only the DataRows  
                                      //having a certain value in a second column
                  foreach (var dataRow in group)
                  {
                      multipleRowsList.Add(dataRow);
                  }
              }
          }
  </code></pre>
  
  <p>I would like to avoid calling foreach ,get only the groups having a count > 1 and then get ONLY 
  the DataRows  that have a second column with a specific value. Thanks!</p>