znkin
Old Hand
Points: 382
More actions
November 3, 2006 at 5:59 am
#92698
How can I display all usernames in my usermaster table which are duplicate. Thanks
Ken McKelvey
SSCoach
Points: 18856
November 3, 2006 at 6:14 am
#669752
SELECT username
FROM usermaster
GROUP BY username
HAVING COUNT(*) > 1
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply