Easy SQL Query Quesion....

Well I need to select name email and address from a table where name doesn't repeat twice. I am not able to use DISTINCT in this case. If I do:

SELECT DISTINCT name, email, address FROM accounts

it still gives me results where all three of them are unique. email and address can repeat but name cannot. What do I do? Please help...

 

 

 

 

Top