当前位置：首页 -> AI编程基础 -> 数据库编程

删除重复数据

2015-07-24 12:04:48 · 作者: · 浏览: 14
标签: 删除 重复 数据
delete from cbe_subscriber a
where rowid !=(select max(rowid)
from cbe_subscriber b
where a.SUBSCRIBERKEY=b.SUBSCRIBERKEY
and a.APPLYTIME=b.APPLYTIME);