Re: finding firstname + lastname groups

Great, thanks!

On Thu, Jun 19, 2008 at 5:14 PM, Sam Mason <sam(at)samason(dot)me(dot)uk> wrote:

> On Thu, Jun 19, 2008 at 03:38:28PM -0400, blackwater dev wrote:
> > The problem is name is not one column but made up of firstname,
> > lastname...how do I do this?
>
> I'd probably do something like:
>
> SELECT firstname, lastname, COUNT(*)
> FROM people
> GROUP BY firstname, lastname
> HAVING COUNT(*) > 1;
>
>
> Sam
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>