Great, thanks! On Thu, Jun 19, 2008 at 5:14 PM, Sam Mason <[EMAIL PROTECTED]> 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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
