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 Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to