July 2013 5:11 AM
Subject: [GENERAL] Removing duplicates
I have used this method successfully on another table but this one is not
working.
I have a table of nearly 800 million records with some duplicates in.
Here is an example:
select rart_id, r9, ra, ry, rw, rv, rp, rs, ri
from is
Dear Johann,
I tried (with PostgreSQL 9.2) to run the two DELETE statements you
describe in your mail (the first based on the "id" field, the second on
the ctid) and they work! I have to point out that if you use the DELETE
based on the "id" field YOU'LL DELETE ALL RECORDS having at least one
I have used this method successfully on another table but this one is not
working.
I have a table of nearly 800 million records with some duplicates in.
Here is an example:
select rart_id, r9, ra, ry, rw, rv, rp, rs, ri
from isi.rcited_ref
where rart_id = 'A1986D733500019';
renders a result of
I am dynamically generating a query like below that creates different
combinations of rules by left joining (any number of times) on itself and
avoiding rules with some of the same attributes as part of the joins
conditions e.g.
SELECT count(*)
FROM rules AS t1
LEFT JOIN rules AS t2
Please use a relevant subject for your posts.
On Tue, Feb 08, 2005 at 23:14:57 +0530,
Surabhi Ahuja <[EMAIL PROTECTED]> wrote:
> i have a table in which duplicate rows occur.
>
> now i have to remove the duplicates. Please note that however, only the
> duplicate rows have to be deleted and n
