title: select rows where ID has variation of values
body: <p>I have two columns, an ID, and the other a value which is either 0 or 1.  I am trying to select all Rows for the ID where it has a 0 and a 1, for example,</p>
  
  <pre><code>RowNumber ------------- ID   ------- value  
  1   ------------------- 001  -------   1  
  2   ------------------- 001  -------     1  
  3   ------------------- 001  -------     1  
  4   ------------------- 002  -------     1  
  5   ------------------- 002  -------     0  
  6   ------------------- 003  -------     1  
  7   ------------------- 003  -------     1  
  8   --------------------004 -------      1  
  9  -------------------- 004   -------    0   
  10  ------------------- 004   -------    1     
  </code></pre>
  
  <p>The result should select rows 4, 5, 8, 9, 10</p>