Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Delete Duplicates with Using - Mailing list pgsql-general

From legrand legrand
Subject Re: [GENERAL] Delete Duplicates with Using
Date
Msg-id 1507966359715-0.post@n3.nabble.com
Whole thread Raw
In response to [GENERAL] Delete Duplicates with Using  ("Igal @ Lucee.org" <igal@lucee.org>)
Responses Re: [GENERAL] Delete Duplicates with Using
List pgsql-general
Tree view 
DELETE FROM table_with_duplicates AS T1 USING table_with_duplicates AS T2
WHERE        T1.column_1 = T2.column_1       AND T1.column_2 = T2.column_2       AND T1.column_3 = T2.column_3
ANDT1.row_num < T2.row_num
 




--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: legrand legrand
Date:
Subject: [GENERAL] Where to find development builds of pg for windows
Next
From: "Joshua D. Drake"
Date:
Subject: Re: [GENERAL] time series data