Re: Beginner needs help - Mailing list pgsql-sql

On Thu, Feb 27, 2003 at 23:17:06 +0000, Aaron Chu <astrate@mac.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;