title: Sql Query for Unique and Duplicates in oracle sql?
body: <p>I need to display unique records in one column and duplicates in another column in Oracle?</p>
  
  <pre><code>COL1 COL2
  1     10
  1     10
  2     20
  3     30
  3     30
  
  unique in one set             duplicate in one set
  
  col1  col2                    col1 col2
  2      20                      1    10
                                 1    10
                                 3    30
                                 3    30
  </code></pre>