title: SQL first occurrence of a string
body: <p>I have a query which returns results like</p>
  
  <ul>
  <li>Jim 456 </li>
  <li>Joe 567 </li>
  <li>Joe 789 </li>
  <li>Jane 456</li>
  </ul>
  
  <p>What I want to do is have 456 only appear once and take the first name (Jim).</p>
  
  <p>Query looks like</p>
  
  <pre><code>select 
       p.id_id as num_id, p.FIRST_NAME || ' ' ||  p.LAST_NAME as Name_
  from DWH.V_TABLE p
  where p.id_id &gt; 100
  </code></pre>
  
  <p>The reasons for this is I need each to have only one owner, not two</p>