title: Two qualify clause in same statement in teradata
body: <p>I have a requirement where in think i need two qualify clause in same statement.</p>
  
  <p>I need two column one with correct iD's (duplicate_cnt=1) and other column with all other ids( dup_cnt>1).
  Based on these values i have to update another table. Is this possible in teradata?</p>
  
  <p>This is my table:</p>
  
  <pre><code>Name    Description  Code   Data_Source
  A   XX  101 SCRM
  A   XX  102 SCRM
  A   XX  103 SCRM
  A   XX  104 SCRM
  A   XX  105 SCRM
  A   XX  110 BSCRM
  </code></pre>
  
  <p>This is what i want:</p>
  
  <pre><code>Name    Description Correct_code    Incorrect code  Data_Source
  A   XX  101 102 SCRM
  A   XX  101 103 SCRM
  A   XX  101 104 SCRM
  A   XX  101 105 SCRM
  </code></pre>
  
  <p>Thanks,
  AB</p>