删除重复数据

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

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