Обсуждение: How do I delete duplicate rows in a table?

Поиск
Список
Период
Сортировка

How do I delete duplicate rows in a table?

От
"Wang, Mary Y"
Дата:
Hi,

I have a table that have that duplicate rows.  How do I find them and delete them?

Please advise.
Mary




Re: How do I delete duplicate rows in a table?

От
Ivan Sergio Borgonovo
Дата:
On Mon, 8 Feb 2010 15:32:51 -0800
"Wang, Mary Y" <mary.y.wang@boeing.com> wrote:

> Hi,
>
> I have a table that have that duplicate rows.  How do I find them
> and delete them?

http://www.webthatworks.it/d1/node/page/eliminating_duplicates_place_without_oid_postgresql

Most likely I've learned it here...

--
Ivan Sergio Borgonovo
http://www.webthatworks.it