select ID from YourTable
group by ID
having count(ID) > 1
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You should get a nice list of duplicates ordered by how many dupes there
are..
Cheers,
A
-Original Message-
From: Jeff McKeon [mailto:[EMAIL PROTECTED]
Sent: Monday 08 December 2003 14:20
To: [EMAIL PROTECTED]
Subject: Find duplicates query
I'm trying to search a table for duplicate
I'm trying to search a table for duplicate entries.
A record is a dup if fields Fee, Fie, Foe are equal in two records.
Would this query be correct to search the table for duplicates?
Select Fee,Fie,Foe
>From TableFoo
Group by Fee,Fie,Foe
Having Count(*) > 1;
Thanks,
Jeff
--
MySQL General Mail
