usa group by.

select ...
from ..
where ...
group by nome