I don't know how to create a self join to delete.
I have a syntax error.
thanks,

delete FROM ci as a, ci as b
max(id)
where concat(a.bu, a.ndc)=concat(b.bu,b.ndc) ;