* Aaron Chu <astrate(at)mac(dot)com> [01.03.2003 03:22]:
> 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.
>
> Thanks.
Say you have such a table:
create table person (
name varchar(10) not null,
surname varchar(20) not null
);
Now your select:
select
surname
from
person
group by surname
having count(surname) > 1;
--
Victor Yegorov