Sunday, April 17, 2005

MySQL find duplicate repords example

select address, count(address) as cnt
from mailing_list
group by address
having cnt > 1
order by cnt;

28 comments:

David Dashifen Kees said...

Awesome. Thanks!r

Luke said...

Thank you!

Anonymous said...

Brilliant! Thanks so much.

Anonymous said...

Beautiful, thank you!

Gerry said...

Fantastic!!! Thank you very very much!!

Anonymous said...

very elegant solution .. i was looking for something like this .. thx

Anonymous said...

Thanks!

Anonymous said...

Thank you very much

Anonymous said...

mui bueno iha

Anonymous said...

THANKS! This is so awesome!

Eswar said...

ya very nice easy to undestand

Anonymous said...

Thanks, great tip!

Anonymous said...

Thanx mate.
You rock!

chineerat said...

you are a GOD!
thanks man

Anonymous said...

Awesome tips, thank you

Anonymous said...

2005 and still good! How to display all info from those entries?

Anonymous said...

nice one really helpful!!! thanks

Anonymous said...

Helped a lot, thanks!

Nurul Huda said...

thanks

Anonymous said...

very very helpful

thank you

cazaadotdk said...

Thank you! This query is awesome!

cazaadotdk said...

Thank you! This query is awesome!

Anonymous said...

Thank you.....
Solve my problem

Anonymous said...

thanks works very well.. cheers

Anonymous said...

And how can I see all duplicate entries
(I mean all entries that duplicate)

e shodhana said...

thanks a lot. elegant solution.

Marco Brenna said...

Nice solution! Thank you :)

Anonymous said...

Not working on a database having 90,000 records:( deep trouble