Brain Goo

Carpe Crap ‘em

Brain Goo header image 4

Entries from October 2008

SQL: Select duplicate rows, select indistinct rows

October 27th, 2008 · 1 Comment

Using SQL, MySQL or whatever your favorite database may be, we all know using SELECT DISTINCT will return unique values in case a value appears more than once in a table. How do you fine duplicates? What if I want to know where the duplicates are? The trick is to use count() and compare it [...]

[Read more →]

Tags: How Tos · SQL · mysql