Re: finding firstname + lastname groups

["blackwater dev" <blackwaterdev@xxxxxxxxx>]

Great, thanks!

On Thu, Jun 19, 2008 at 5:14 PM, Sam Mason <sam@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general