Re: Delete duplicated rows

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Thanks to all for your answer (including Duncan that has replied to my
private mailbox), but I think all of them are thinking of removing rows
that have one field that is repeated in other rows.
My problem is that the WHOLE row is repeated, so I have to find
something like this:

FIELDS 1 2 3 4 5 6 7
Row 1 my car is blue and very fast *
Row 2 your car is green and quite fast
Row 3 my car is blue and very fast *
Row 4 my car is blue and very big
Row 5 my car is red and very fast
Row 6 my car is blue and very fast *

* Totally duplicated rows

What do you think about making a query trying to get only the no
duplicated rows, insert them in a temporary table and after deleting all
the rows from the original table reinsert the temporary table's rows
into the empty one?? Perhaps is a little bit silly, but it's the only
way I see....

Thanks once again.

Josep Sànchez
[papapep]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/LpeE2vx52x0kyz4RAvzqAKC1pA27F1u/mzoPs6BY1bFgaGQk6wCeL40U
whmWGXWGT56Ec61vC81yorA=
=exh7
-----END PGP SIGNATURE-----