How to delete duplicate record

From: Abdul Wahab Dahalan <wahab(at)mimos(dot)my>
To: pgsql-sql(at)postgresql(dot)org
Subject: How to delete duplicate record
Date: 2003-02-10 01:48:27
Message-ID: 3E4704EA.A7A813CC@mimos.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

How do I delete a duplicated records?
Here I've 7 duplicated records and tried to delete 6 from them.

I tried this query but has error
b2b=> delete from biztypes where bizid = (select bizid from biztypes
where bizid = 'B116' limit 6);
ERROR: More than one tuple returned by a subselect used as an
expression.

I tried this query, but all records are deleted.
b2b=> delete from biztypes where bizid = (select bizid from biztypes
where bizid = 'B116' limit 1);
DELETE 7

Any help are very much appreciated..
Thanks. Wahab

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Frankie Lam 2003-02-10 03:39:54 Re: plpgsql + dblink() question
Previous Message Tomasz Myrta 2003-02-10 00:36:47 Re: How to delete duplicate record