RE: find all records with more than one occurrence

Hi, How can I check all duplicated rows out from a large table? The values are not keys so they may have more than one occurrence. Thanks for your help. Regards, CHAN Chan, what about using DISTINCT in the select? .. or am I missing something? Kind Regards SciBit MySQL Team

Re: find all records with more than one occurrence

At 08:49 AM 12/15/2004, you wrote: Hi, How can I check all duplicated rows out from a large table? The values are not keys so they may have more than one occurrence. Thanks for your help. Regards, CHAN Try something like: select count(*) num, colvalue from table1 group by colvalue having num 1