на память

[faraon]

select aName, Count(aName) as Count
from Table
group by aName
having count(aName)>1