Re: [GENERAL] how to remove the duplicate records from a table

Robert Treat wrote: >>> I have a table contains some duplicate records, and this table create >>> without oids, for example: >>> id | temp_id >>> +- >>> 10 | 1 >>> 10 | 1 >>> 10 | 1 >>> 20 | 4 >>> 20 | 4 >>> 30 | 5 >>> 30 | 5 >>> I want

Re: [GENERAL] how to remove the duplicate records from a table

On Tuesday 07 October 2008 05:48:01 Albe Laurenz wrote: > Yi Zhao wrote: > > I have a table contains some duplicate records, and this table create > > without oids, for example: > > id | temp_id > > +- > > 10 | 1 > > 10 | 1 > > 10 | 1 > > 20 | 4 > > 20 |

Re: [GENERAL] how to remove the duplicate records from a table

Yi Zhao wrote: > I have a table contains some duplicate records, and this table create > without oids, for example: > id | temp_id > +- > 10 | 1 > 10 | 1 > 10 | 1 > 20 | 4 > 20 | 4 > 30 | 5 > 30 | 5 > I want get the duplicated records r

Re: [GENERAL] how to remove the duplicate records from a table

2008/10/7 Yi Zhao <[EMAIL PROTECTED]>: > I have a table contains some duplicate records, and this table create > without oids, for example: > id | temp_id > +- > 10 | 1 > 10 | 1 > 10 | 1 > 20 | 4 > 20 | 4 > 30 | 5 > 30 | 5 > I want get t

[GENERAL] how to remove the duplicate records from a table

I have a table contains some duplicate records, and this table create without oids, for example: id | temp_id +- 10 | 1 10 | 1 10 | 1 20 | 4 20 | 4 30 | 5 30 | 5 I want get the duplicated records removed and only one is reserved, so th