On Thu, Jun 19, 2008 at 5:14 PM, Sam Mason <sam@samason.me.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;