Monday, February 6, 2012

find duplicate rows in a mysql table

example field = reference
example table = outstandings


" select reference from outstandings group by reference having count(*)>=2 "

No comments:

Post a Comment