
How to find duplicate rows?
Von Tobias Arnhold →
6.08.2011
Basically with a single table you do like this:SELECT COLUMN_A, COLUMN_B, COUNT(*)FROM MY_TABLEGROUP BY COLUMN_A, COLUMN_BHAVING COUNT(*)>1;If you...