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 I

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 M

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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMA