Re: SQL Too difficult for me do you know how?

Just one statement will do the job:

delete <table_name>
where recordid not in (

    select max(recordid) from <table_name>     group by clientid, addressid );

regards
bjin

Jobi wrote:

> Hi,
>
> I have a Table with somewhat duplicate record and I would like to delete
> the duplicates Here is an Exemple of the table:
>
> RecordID ClientID AddressID
>
> 1 688 123
> 2 688 123
> 3 783 142
> 4 783 143
>
> Note: RecordID is created on Insert to provide a Unique Number to Index On.
> It is NOT ROWID
>
> Now What I would like to do is get rid of All but ONE of the Records that
> Have the Same ClientID AND AddressID....
>
> Thanks for your help....
>
> Eric
Received on Thu Mar 04 1999 - 23:45:48 CST