删除重复数据

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

版权声明：本文博主原创文章，博客，未经同意不得转载。

转载于:https://www.cnblogs.com/bhlsheji/p/4807780.html