删除重复数据
delete from cbe_subscriber a
where rowid !=(select max(rowid)
from cbe_subscriber b
where a.SUBSCRIBERKEY=b.SUBSCRIBERKEY
and a.APPLYTIME=b.APPLYTIME);
where rowid !=(select max(rowid)
from cbe_subscriber b
where a.SUBSCRIBERKEY=b.SUBSCRIBERKEY
and a.APPLYTIME=b.APPLYTIME);
版权声明:本文博主原创文章,博客,未经同意不得转载。