i have a table with no primary key or id column. each record is duplicated anywhere from 3 to 12 times.there are about 30 columns in the table. how do i get rid of the duplicates? could it be as simple as select distinct?
the only thing im worried about when using distinct, is that, there might be 12 duplicates of the same row, but im afraid that even though some rows may have the same customerID and period, the other figures may be different( i.e just because some rows for a customer may be duplicates , some might not be)