title: SQL select only first with a given name
body: <p>Houses</p>
  
  <pre><code>id OwnerId    street
  -----------------------
  1  owner1     street1
  2  owner2     street1
  3  owner3     street2
  4  owner4     street2
  5  owner5     street3
  </code></pre>
  
  <p>As you can see there can be more owners on the same street</p>
  
  <p>I have another table where I want to insert the owners from <code>Houses</code> table, but only one from each street</p>
  
  <p>Result of query:</p>
  
  <p>table StreetRepresentant</p>
  
  <pre><code>ownerId    street 
  ------------------
  owner1     street1
  owner3     street2
  owner5     street3
  </code></pre>
  
  <p>(<code>ownerId</code> is the PK for the table, if it matters. <code>OwnerId</code> is a unique in table <code>Houses</code>)</p>
  
  <p>The query should be something like:</p>
  
  <pre><code>INSERT INTO StreetRepresentant (ownerId , street ) 
  SELECT ownerId , street 
  FROM Houses
  --what should be here to get only 1 owner for each street? ... 
  </code></pre>