How to delete duplicate record

Поиск
Список
Период
Сортировка
От Abdul Wahab Dahalan
Тема How to delete duplicate record
Дата
Msg-id 3E4704EA.A7A813CC@mimos.my
обсуждение
Ответы Re: How to delete duplicate record
Re: How to delete duplicate record
Re: How to delete duplicate record
Список 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




В списке pgsql-sql по дате отправления: