-
Remove redundant rows
how to remove redundant rows without any distinct columns in the table itself ?
smonroy
- Sep 27th, 2011
Hi my Friend this is the best way to you issue DELETE FROM table_name where camp1 in (SELECT camp1 FROM table_name GROUP BY camp1 HAVING Count(camp1)>1) Example: DELETE FROM ubication where serial...
Allan Hunter
- Sep 22nd, 2011
You're question is vague, but from what I understand it to mean is to remove duplicate rows wihle keeping the columns in tact. The easiest way I know is to make your query based on what makes the dat...
