A problem in SQL (a real challenge)

From: thought <fahd_kamalNOfaSPAM_at_hotmail.com.invalid>
Date: 2000/05/04
Message-ID: <22fe7a4c.ec04d43a_at_usw-ex0105-040.remarq.com>#1/1

Suppose I have a table without a primary key (or for that matter any key). I want to delete duplicate entries from the table using a SINGLE SQL statement. Can anyone there help me out?

Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!

Received on Thu May 04 2000 - 00:00:00 CEST

This message: [ Message body ]
Next message: Joe Celko: "Re: Does Ingres 2 meet the 12 rules of E.F. Codd?"
Previous message: Bigpond: "Database Design and Modelling"
Next in thread: Kyle Lahnakoski: "Re: A problem in SQL (a real challenge)"
Reply: David Cressey: "Re: A problem in SQL (a real challenge)"
Reply: Thomas Muller: "Re: A problem in SQL (a real challenge)"
Reply: Frédéric BROUARD: "Re: A problem in SQL (a real challenge)"
Reply: Kyle Lahnakoski: "Re: A problem in SQL (a real challenge)"

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

Original text of this message