Re: finding firstname + lastname groups

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