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

I think the quickest way which does not involve correlated subqueries is

delete from [table] where rowid in
(select rowid from [table] minus
select max(rowid) from [table] group by clientID, AddressID).

In my experience, this outperforms
correlated subqueries
 by 50-1000% Received on Fri Mar 05 1999 - 00:24:14 CST