Home >Database >Mysql Tutorial >查找重复记录
查找重复记录
- WBOYOriginal
- 2016-06-07 14:54:42999browse
无详细内容 无 select * from rm_duty a where exists(select 1 from rm_duty b where b.duty_name=a.duty_name and a.rowidb.rowid )
select * from rm_duty a where exists(select 1 from rm_duty b where b.duty_name=a.duty_name and a.rowid>b.rowid )
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：Access如何在字段定义主键Next article：统计数据库每天的数据增长量