title: Row_Number/Partition By, getting all result sets that are more than one value
body: <p>I'm using ROW_NUMBER() and PARTITION BY to create a table that looks like this:</p>
  <pre><code>   VALUE     ID   ROWNUM 
      A       4525     1
      B       4526     1
      C       4527     1
      D       4530     1
      E       4530     2
      F       4530     3
      G       4531     1
      H       4531     2
  </code></pre>
  <p>I want to get rid of the partitions that consist of only one value. A, B, and C will be gone, but D through H will stay because they're in partitions that contain more than one value. In other words, what can I do to my query to make the results look like this:</p>
  <pre><code>   VALUE     ID    ROWNUM 
      D       4530     1
      E       4530     2
      F       4530     3
      G       4531     1
      H       4531     2
  </code></pre>
  <p>I can't filter by ROWNUM &gt; 1 because I want to keep some of the columns where ROWNUM = 1, but figuring out how to keep <em>only</em> some of those columns is stumping me.</p>