mySQL
费霄霄
这个作者很懒,什么都没留下…
展开
-
leetcode刷题175
题目描述 实现代码 SELECT FirstName, LastName, City, State FROM Person LEFT OUTER JOIN Address ON Person.PersonId = Address.PersonId; SQL知识点 外联结-OUTER JOIN原创 2019-01-01 14:42:01 · 90 阅读 · 0 评论 -
leetcode刷题182
题目描述 解法代码 SELECT Email FROM Person GROUP BY Email HAVING COUNT(*)>1; SQL知识点 数据分组-GROUP BY 过滤分组-HAVING原创 2019-01-01 16:46:56 · 110 阅读 · 0 评论 -
leetcode刷题183
题目描述 解法代码 SELECT Customers.Name AS Customers FROM Customers LEFT JOIN Orders ON Customers.ID=Orders.CustomerId WHERE CustomerId is NULL; SQL知识点 外联结-OUTER JOIN原创 2019-01-01 19:35:11 · 103 阅读 · 0 评论 -
leetcode刷题196
题目描述 解法代码 DELETE FROM Person WHERE Id IN ( SELECT a.Id FROM ( SELECT P1.Id FROM Person AS P1,Person AS P2 WHERE P1.Id>P2.Id AND P1.Email=P2.Email ) AS a); SQL知识点 删除数据-DELETE FROM ...原创 2019-01-01 21:18:40 · 100 阅读 · 0 评论