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

Hi Eric,

Sybrand's code is partially correct as pointed out by pradan.

Try this code and see if you can get the correct solution.

delete from table x
where x.recordid <
(select max(recordid)
 from table y
 where y.clientid = x.clientid
 and y.addressid = x.addressid)

RBG Received on Fri Mar 05 1999 - 00:23:53 CST