search

Home >Database >Mysql Tutorial >删除重复数据

删除重复数据

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-07 16:05:151028browse

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

delete from cbe_subscriber a
where rowid !=(select max(rowid)
from cbe_subscriber b
where a.SUBSCRIBERKEY=b.SUBSCRIBERKEY
and a.APPLYTIME=b.APPLYTIME);
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：HBase之普通BulkLoadNext article：归档日志(下)

Related articles

See more