简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

删除重复的记录,并保存第一条记录或保存最后一条记录

WBOY
Release： 2016-06-07 17:56:49
Original
954 people have browsed it

删除重复的记录,并保存第一条记录或保存最后一条记录

删除表:dgpage中Mail重复的记录并保留最后一条.
delete dgpage where id in ( select a.id from dgpage a, dgpage b where a.mail = b.mail and a.id > b.id )


删除表:dgpage中Mail重复的记录并保留最近一条.
delete dgpage where id in ( select a.id from dgpage a, dgpage b where a.mail = b.mail and a.id
Related labels：
删除重复的记录 并保存第一条记
source：php.cn
Previous article：SQL Server全文索引服务 Next article：如何在SQLSERVER中快速有条件删除海量数据
Statement of this Website
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
Latest Articles by Author
Latest Issues
The entity warehouse extends JpaRepository<Entity, Id> and JpaSpecificationExecutor<Entity>, and EntitySpec extends Specification<Entity> This is my endpoint http://localhost:8080/country/all replies are ok for all countries and...
From 2024-04-06 17:11:03
0
1
421
Angular 7 remove duplicate attributes in SCSS AngularSASS (.scss) strips properties. How do I prevent this from happening so I can embed...
From 2024-04-04 23:28:54
0
1
1382
Authserver "Unable to connect" "Host xxxxx is not authorized" after changing the LAN installation IP Use the default Windows installation instructions on a bare metal Windows 10 installation....
From 2024-04-04 15:06:41
0
1
374
Steps to remove a foreign key entry I have two tables Employee and Address. Employee is my main table and Address is a subtabl...
From 2024-04-04 14:15:44
0
1
352
Choose the appropriate application architecture to handle bearer tokens I want to use an API that uses OAuth2.0 In short, I need to obtain an access token that I ...
From 2024-04-04 08:55:57
0
1
353
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！