Hi ,
Try this query...
SELECT COUNT(*), column1, column2 FROM tablename
GROUP BY column1, column2
HAVING COUNT(*)>1;
Thanks,
ViSolve DB Team
----- Original Message -----
From: "Tomás Abad Fernández" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Tuesday, February 06, 2007 9:57 PM
Subject: How find duplicate entries
Any can tell me a slq to find duplicate entries in a table?
Thanks,
Tomás
--------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.411 / Virus Database: 268.17.27/671 - Release Date: 2/5/2007
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]