摘要: # Write your MySQL query statement below --题意:删除重复的邮箱,保留重复中邮箱id最小的 --逆向思维,删除每个邮箱中不是最小的 DELETE FROM person WHERE id NOT IN ( SELECT need.id FROM ( SELE 阅读全文
posted @ 2020-01-12 16:49 小傻孩丶儿 阅读(216) 评论(0) 推荐(0) 编辑
摘要: SELECT d.Name AS 'Department', e1.Name AS 'Employee', e1.Salary FROM Employee e1 JOIN Department d ON e1.DepartmentId = d.Id WHERE --子查询 逆向思维 3 > (SEL 阅读全文
posted @ 2020-01-12 15:22 小傻孩丶儿 阅读(107) 评论(0) 推荐(0) 编辑
摘要: import java.util.ArrayList; import java.util.List; /** * Given an array nums of n integers and an integer target, are there elements * a, b, c, and d 阅读全文
posted @ 2020-01-12 14:47 小傻孩丶儿 阅读(145) 评论(0) 推荐(0) 编辑
摘要: import java.util.ArrayList; import java.util.LinkedList; import java.util.List; /* * Given a string containing digits from 2-9 inclusive, return all p 阅读全文
posted @ 2020-01-12 14:15 小傻孩丶儿 阅读(171) 评论(0) 推荐(0) 编辑