I've tested this on a table of mine with different names, so it should work when you
tweak your columns/table. The "having clause" is a seldom taught, but highly useful
clause.
select count(1), first_name, last_name
from myuserstable
group by first_name, last_name
having count(1) > 1;
You sho
Fibilt
try:
SELECT id, concat(lname, fname) as name, count(*) as cnt
FROM table1
GROUP BY name
HAVING cnt > 1;
This is close anyhow.
David
> -Original Message-
> From: Phillip S. Baker [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 16, 2002 1:17 PM
> To: [EMAI