Re: finding firstname + lastname groups - Mailing list pgsql-general

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