delete from cbe_subscriber a where rowid !=(select max(rowid) from cbe_subscriber b where a.subscriberkey=b.subscriberkey and a.applytime=b.applytime);
delete from cbe_subscriber a
where rowid !=(select max(rowid)
from cbe_subscriber b
where a.subscriberkey=b.subscriberkey
and a.applytime=b.applytime);