首页 > 代码库 > 删除重复数据

删除重复数据

2024-07-27 21:35:23   223人阅读

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

删除重复数据


联系
我们