SQL select only first with a given name -

houses

id ownerid    street ----------------------- 1  owner1     street1 2  owner2     street1 3  owner3     street2 4  owner4     street2 5  owner5     street3 

as can see there can more owners on same street

i have table want insert owners houses table, 1 each street

result of query:

table streetrepresentant

ownerid    street  ------------------ owner1     street1 owner3     street2 owner5     street3 

(ownerid pk table, if matters. ownerid unique in table houses)

the query should like:

insert streetrepresentant (ownerid , street )  select ownerid , street  houses --what should here 1 owner each street? ...  

you can group street, use min() function return lowest (as per example) ownerid each street.

select min(ownerid) , street  houses group street