title: Oracle - Select all records based on one distinct column, table with many columns
body: <p>I need to select all records from a view but disctinct on one column.  The view has many colums so I don't want to place disctinct before all columns within the query ; and they  may increase</p>
  
  <p>e.g. </p>
  
  <pre><code>post_code   name    last_name   col_a   col_b   col_c   col_d   col_e col n...
  A1 123  Abi      Smith          a       a       a       a       a       
  A1 123  Barb    BarbLastName    b       c       d       b       c       
  B1 123  Cart    CartLastName    b       c       d       b       c       
  C3 123  Dilbert DilberLastName  b       c       d       b       c       
  D4 123  Edgar   EdgarLastName   b       c       d       b       c       
  D4 123  Fred    FredLasName     b       c       d       b       c           
  </code></pre>
  
  <p>so something like select * records by distinct post code and return all the first (or any) of them</p>
  
  <pre><code>A1 123  Abi      Smith          a       a       a       a       a       
  B1 123  Cart    CartLastName    b       c       d       b       c   
  C3 123  Dilbert DilberLastName  b       c       d       b       c   
  D4 123  Fred    FredLasName     b       c       d       b       c
  </code></pre>
  
  <p>Thanks</p>