| 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?