title: Find which rows have different values for a given column in Teradata SQL
body: <p>I am trying to compare two addresses from the same ID to see whether they match. For example:</p>
  
  <pre><code>Id  Adress Code     Address
  1   1               123 Main
  1   2               123 Main
  2   1               456 Wall
  2   2               456 Wall
  3   1               789 Right
  3   2               100 Left
  </code></pre>
  
  <p>I'm just trying to figure out whether the address for each ID matches. So in this case I want to return just ID 3 as having a different address for Address Code 1 and 2.</p>