bmanmike39
asked on
How would write a query against a MySql db that returns all userName records greater than one record?
How would write a query against a MySql db that returns all userName records greater than one record? I'm looking for duplicate records in the table.
I'm looking for any duplicated usernames in the table not just a single.
Thanks!
SELECT * FROM members WHERE UserName count < 1
I'm looking for any duplicated usernames in the table not just a single.
Thanks!
SELECT * FROM members WHERE UserName count < 1
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER