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 по дате отправления: