183. Customers Who Never Order (LeetCode, SQL)
来源:互联网 发布:编程求出玫瑰花数 编辑:程序博客网 时间:2024/06/06 22:40
183. Customers Who Never Order
Suppose that a website contains two tables, the Customers table and the Orders table. Write a SQL query to find all customers who never order anything.
Table: Customers.
Table: Orders.
Using the above tables as example, return the following:
解法1:
NOT IN
SELECT Name AS Customers From Customers WHERE Id NOT IN (SELECT CustomerId FROM Orders)
解法二:
LEFT JOIN
- INNER JOIN(内连接,或等值连接):获取两个表中字段匹配关系的记录。
- LEFT JOIN(左连接):获取左表所有记录,即使右表没有对应匹配的记录。
- RIGHT JOIN(右连接): 与 LEFT JOIN 相反,用于获取右表所有记录,即使左表没有对应匹配的记录。
SELECT Name AS CustomersFROM Customers c left join Orders o on c.Id=o.CustomerIdWHERE o.CustomerId IS NULL;
0 0
- 183. Customers Who Never Order (LeetCode, SQL)
- 【leetcode SQL】Customers Who Never Order
- LEETCODE database 183. Customers Who Never Order
- leetcode 183. Customers Who Never Order
- leetcode.183. Customers Who Never Order
- 【leetcode Database】183. Customers Who Never Order
- leetcode 183. Customers Who Never Order
- Leetcode 183. Customers Who Never Order
- leetcode 183. Customers Who Never Order
- LeetCode笔记:183. Customers Who Never Order
- leetcode 183. Customers Who Never Order
- LeetCode | Customers Who Never Order
- Leetcode : Customers Who Never Order
- LeetCode Customers Who Never Order
- Leetcode Customers Who Never Order
- Leetcode: Customers Who Never Order
- 【Leetcode】Customers Who Never Order
- SQL-Customers Who Never Order
- Kotlin搞起来——2.基础知识
- 去除android应用全屏时屏幕上方显示的“Swipe down from the top to exit full screen”提示
- WebRTC学习资料大全
- UVa 1602 Lattice Animals 网格动物
- JavaScript获取select元素下的每一个option
- 183. Customers Who Never Order (LeetCode, SQL)
- git 切换到develop分支时 提示error: The following untracked working tree files would be overwritten by check
- 欢迎使用CSDN-markdown编辑器
- The provider is not compatible with the version of Oracle client sometimes (提供程序与此版本的 Oracle 客户机不兼容)
- CxImage的编译及简单使用举例
- C#中类似Java中Map集合Properties的类Dictionary
- UVa 580 Critical Mass
- 温习小知识--mutex和spin lock的区别和应用
- APP压力测试入门教程