RE: sql-question

Posted in 1999

Scott Black — Tue, 29 Jun 1999 09:34:12 -0400 — source: Informix-list mailing list archive (1991-1998)

Without offering any advice about your schema which may need to be re-worked... Try: Select min(rowid) From table_id Where {300 records}; Delete from table_id Where rowid = {above statement} -----Original Message----- From: Dieter Powroznik [SMTP:dieter.powroznik@depot147.dpd.de] Posted At: Tuesday, June 29, 1999 6:54 AM Posted To: Informix Conversation: sql-question Subject: sql-question Hi! I have in a table 250000 data records. 300 of this records are duplicate in one field. How can i with a sql-statement delete one of this duplicate records. There are no index on this table. Thanks for help! Dieter