List:General Discussion« Previous MessageNext Message »
From:ViSolve DB Team Date:February 7 2007 4:47am
Subject:Re: How find duplicate entries
View as plain text  
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" <informatica@stripped>
To: <mysql@stripped>
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

Thread
How find duplicate entriesTomás Abad Fernández6 Feb
  • Re: How find duplicate entriesLars Schwarz6 Feb
  • Re: How find duplicate entriesBrent Baisley6 Feb
  • Re: How find duplicate entriesViSolve DB Team7 Feb