title: Oracle 11g SQL to get unique values in one column of a multi-column query
body: <p>Given a table <strong>A</strong> of people, their native language, and other columns C3 .. C10 represented by <strong>...</strong></p>
  
  <h3>Table A</h3>
  
  <pre>
  PERSON   LANGUAGE   ...
  bob      english
  john     english
  vlad     russian
  olga     russian
  jose     spanish
  </pre>
  
  <p>How do I construct a query which selects all columns of one row for each distinct language?</p>
  
  <h3>Desired Result</h3>
  
  <pre>
  PERSON   LANGUAGE   ...
  bob      english
  vlad     russian
  jose     spanish
  </pre>
  
  <p>It doesn't matter to me which row of each distinct language makes the result. In the result above, I chose the lowest row number of each language.</p>