Re: SQL statement to find and delete double entries

[Christian Merz]

Hi,

the basic idea to find duplicate or multiple values is:
    select id, count(*)
    from table
    group by id
    having count(*) > 1;

to delete ALL such values you may do this:
    delete from table where id in
      ( select id
        from table
        group by id
        having count(*) > 1
     );

cu, Christian

----- Original Message -----
From: "Morrison, Trevor (Trevor)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 16, 2003 6:39 PM
Subject: SQL statement to find and delete double entries


Hi,

What would be an SQL statement that will find duplicate order numbers in
table and then delete them?

TIA

Trevor