Need to delete duplicate rows

From: ******** <NICKB_at_KUBOTA.CO.UK>
Date: 2000/04/17
Message-ID: <38fae4cb.0_at_tahiti.alcom.co.uk>#1/1

Our Oracle database receives data from AS/400 on a daily basis. Unfortunately, for whatever reason, Oracle has imported (from AS/400) into my 'SALES' table a duplicate row for each record that exists. For e.g.:

item_code: invoice_date: serial_no: engine_no: sales_qty:

x234-88        03-APR-00        45677        DE4344        1
x234-88        03-APR-00        45677        DE4344        1

I would be grateful if anyone could please tell me how I could use SQL to remove the duplicate rows from my table.

Many thanks.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Mon Apr 17 2000 - 00:00:00 CEST

This message: [ Message body ]
Next message: David Cressey: "Re: Need to delete duplicate rows"
Previous message: APTurner_at_aol.com: "One-to-many database with merge requirement"
Next in thread: David Cressey: "Re: Need to delete duplicate rows"
Reply: David Cressey: "Re: Need to delete duplicate rows"
Reply: Thomas Muller: "Re: Need to delete duplicate rows"
Reply: Karl Hewlett: "Re: Need to delete duplicate rows"
Reply: Joe Celko: "Re: Need to delete duplicate rows"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message