removing duplicates rows

From: al <asalvado_at_ev1.net>
Date: Thu, 24 Jun 1999 19:39:06 -0500
Message-ID: <gjAc3.5747$d5.725031_at_news21b.ispnews.com>

[Quoted] [Quoted] If a tables rows are accidently duplicated, how do you remove duplicates?

1st you can count the rows, and then use this count in the following SQL: DELETE: FROM table
WHERE rownum < ( (row_count/2) + 1);

This works only if you duplicated the rows all at once. What's the proper way of doing it?

Thanks. Received on Fri Jun 25 1999 - 02:39:06 CEST