【MySQL】【leetcode】 Delete Duplicate Emails解题报告
来源:互联网 发布:蜘蛛池外推软件 编辑:程序博客网 时间:2024/05/16 14:23
题目
Write a SQL query to delete all duplicate email entries in a table named Person, keeping only unique emails based on its smallest Id.
Id is the primary key column for this table.
For example, after running your query, the above Person table should have the following rows:
题目来源:https://leetcode.com/problems/delete-duplicate-emails/
代码
Email重复的话,保留ID最小的那条记录,其余的删除。
#方法一:# Write your MySQL query statement belowdelete from Personwhere Id not in ( select * from ( select MIN(Id) from Person group by Email ) as tb);#方法二:# Write your MySQL query statement belowdelete p1 from Person as p1, Person as p2where p1.Email = p2.Email and p1.Id > p2.Id;
0 0
- 【MySQL】【leetcode】 Delete Duplicate Emails解题报告
- 【MySQL】【leetcode】 Duplicate Emails解题报告
- [LeetCode]Duplicate Emails,解题报告
- LeetCode Delete Duplicate Emails
- Delete Duplicate Emails LeetCode
- Leetcode Delete Duplicate Emails
- [leetcode]Delete Duplicate Emails
- 【Leetcode】Delete Duplicate Emails
- MySQL-Delete Duplicate Emails
- [LeetCode][Database]Delete Duplicate Emails
- 【Leetcode Database】Delete Duplicate Emails
- 【leetcode】 database Delete Duplicate Emails
- [LeetCode] 196. Delete Duplicate Emails
- LeetCode 196. Delete Duplicate Emails
- leetcode.196. Delete Duplicate Emails
- leetcode 196. Delete Duplicate Emails
- [LeetCode]--196. Delete Duplicate Emails
- Leetcode 196. Delete Duplicate Emails
- openssh FAQ
- Objective-C categories in static library链接库真实链接的大小
- VS2005下使用VC,部分断点无效,显示『当前不会命中断点。还没有为该文档加载任何符号』。
- tableViewcell上进行手势的添加
- 初次使用Qt Creater网络编程,出现error: undefined reference to `_imp__WSAStartup@8'
- 【MySQL】【leetcode】 Delete Duplicate Emails解题报告
- Android之调用微信登陆、分享、支付
- Eclipse中hadoop2.7.1的插件下载及安装步骤
- DWZ文件上传,time转化
- spark mllib 中的tf-idf算法计算文档相似度
- 取得硬盘剩余空间的Java代码
- mysql 和oracle的函数比较
- 获取当前位置信息
- merge k sorted lists