Re: A problem in SQL (a real challenge)

To my knowledge, the closest you are going to get is to make a copy of the table, with duplicates eliminated.

The basic approach is a create table command with a "select distinct" query in it. This query
would request all the rows and columns of the source table, but the word distinct would suppress duplicates.

The create table with a query in it may be non standard SQL. I don't know. It is supported by Oracle.

A select distinct on a huge table will probably result in a huge sort. This could take a while to process.

David Cressey

david_at_dcressey.com

using
thought wrote in message <22fe7a4c.ec04d43a_at_usw-ex0105-040.remarq.com>...
>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 Fri May 05 2000 - 00:00:00 CEST