Subject | delete duplicate row |
---|---|
Author | Tiago Mikhael Pastorello Freire |
Post date | 2006-12-12T13:18:15Z |
Dear all,
I have this table which stores the values of a looong questionnaire, and there
are some duplicated entries. There are some complications. It was not
developed by me, and it was rushed online. The genius has not created a
primary key or any constraint to define the records by their uniquenes, nad
thus we have a few exact duplicate rows which I should delete all but one.
can someone spare me a bit of magic code to delete the duplicated entries and
leave only one record?
I have this table which stores the values of a looong questionnaire, and there
are some duplicated entries. There are some complications. It was not
developed by me, and it was rushed online. The genius has not created a
primary key or any constraint to define the records by their uniquenes, nad
thus we have a few exact duplicate rows which I should delete all but one.
can someone spare me a bit of magic code to delete the duplicated entries and
leave only one record?