mysql> select count(*) - count(distinct username,email) as 'duplicate names' from users; +-----------------+ | duplicate names | +-----------------+ | 2 | +-----------------+ 1 row in set (0.00 sec)
I got this select syntax to count how many duplicate entries i have. But i dont know how to show the duplicate entries i have on that table. Pls help! -- Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
