On Thu, Feb 27, 2003 at 23:17:06 +0000,
Aaron Chu <astrate(at)mac(dot)com> 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 from whatevertable group by surname having count(*) > 1
order by surname;