Aaron Chu wrote:
> Hi,
>
> I have a table which has a column of surnames (string) and I would like
> to know how can I retrieve (SELECT) all the repeated surnames, i.e.
> more than one person who has the same surname.
select surname, count('a') from table
group by surname
having count('a') > 1
order by surname
/Björn