title: SQL: Return additional fields as columns grouped by SSN
body: <p>Our Oracle DB has people in it with a unique ID. If a person is entered multiple times there will be multiple rows with the same demographic information (SSN, Name, Address, etc) with a uniquely generated ID. What I need to do is take unique rows and pull out just the person ID(s) into columns on a single row.</p>
  
  <p>Table Data:</p>
  
  <pre><code>Person ID | SSN | Name
  ----------------------
  1234567890 | 123-12-1234 | John Doe
  0987654321 | 123-12-1234 | John Doe
  1234567891 | 126-16-1236 | Jim Doe
  1234567892 | 126-16-1236 | Jim Doe
  </code></pre>
  
  <p>Desired Results:</p>
  
  <pre><code>Person ID | Person ID | SSN | Name
  ----------------------
  1234567890 | 0987654321 | 123-12-1234 | John Doe
  1234567891 | 1234567892 | 126-16-1236 | Jim Doe
  </code></pre>
  
  <p>I'm relatively new to SQL so if this is a really dumb/easy solution great!</p>