Following on from Dave's response....
You only need one query, which selects the Min ID, Min Name and GroupBy Address,
SELECT Min(id) AS id, Min(Name) AS Name, Address
GROUP BY Address;
I am a loud man with a very large hat. This means I am in charge