title: Linq-to-SQL Help - Selecting Duplicate Rows
body: <p>So this is what I am trying to do:</p>
  
  <pre><code>select subscriber, count(subscriber)
  from subscribers
  where subscriber = subscribedTo
  group by subscriber
  having count(subscriber) &gt; 1
  </code></pre>
  
  <p>Easy enough in SQL.  I can't figure out how to write this in LINQ.  Anyone know how to go about this?</p>
  
  <p>The table is just three cols, ID, subscriber and subscribedTo.  I am trying to find duplicate rows where the subscriber == subscribedTo.</p>