If the email address is all you need, you could try this

SELECT DISTINCT(Email) from YourTable

WHERE ID = '1'

or this but you will probably have mulitple rows returned so it would...