LeetCode | Customers Who Never Order
来源:互联网 发布:上外翻译总公司 知乎 编辑:程序博客网 时间:2024/05/24 01:45
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
.
+----+-------+| Id | Name |+----+-------+| 1 | Joe || 2 | Henry || 3 | Sam || 4 | Max |+----+-------+
Table: Orders
.
+----+------------+| Id | CustomerId |+----+------------+| 1 | 3 || 2 | 1 |+----+------------+
Using the above tables as example, return the following:
+-----------+| Customers |+-----------+| Henry || Max |+-----------+
想到两种方法:left join,not in。
not in:
select Customers.Name
from Customers
where Customers.Id not in (select distinct CustomerId from Orders);
left join:
SELECT Name
FROM Customers c LEFTJOIN Orders o ON c.Id = o.CustomerId
WHERE o.Id ISNULL;
在网上还看见一种方法:not exists:
SELECT Name FROM Customers c
WHERENOTEXISTS (SELECT CustomerId FROM Orders o WHERE o.CustomerId = c.id);
0 0
- 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
- 【leetcode SQL】Customers Who Never Order
- [LeetCode][Database]Customers Who Never Order
- 【Leetcode】 database Customers Who Never Order
- [Leetcode] [Database] Customers Who Never Order解题
- Database Leetcode 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
- uboot环境变量实现分析
- [经典面试题][百度]数轴上从左到右有n各点a[0], a[1], ……,a[n -1],给定一根长度为L的绳子,求绳子最多能覆盖其中的几个点。
- 2015.2.8--记录我的机器学习之路--现代启发式算法之蚁群算法
- UVA 1352 Colored Cubes(回溯)
- 字符串的拷贝
- LeetCode | Customers Who Never Order
- codeforces Rockethon 2015
- CentOS下多节点Openstack安装(三)—— glance安装
- 医联网!
- Maximum Product Subarray
- 数据结构(陈越)PAT练习题 第六周:图(下)
- CentOS下多节点Openstack安装(五)—— cinder安装
- (十一)桥梁模式
- 更好的使用google www.google.com/ncr