MySQL-Customers Who Never Order
来源:互联网 发布:jenkins 源码管理配置 编辑:程序博客网 时间:2024/05/16 05:16
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 |+-----------+
Subscribe to see which companies asked this question.
题目大意:
假设一个网站包含两个表, 顾客表Customers和订单表Orders。编写一个SQL查询找出所有从未下过订单的顾客。
解题思路:
使用NOT IN,NOT EXISTS,或者LEFT JOIN均可。
使用NOT IN
# Write your MySQL query statement belowselect c1.Name as Customers from Customers c1 where c1.Id not in (select o.CustomerId from Orders o) order by c1.Id;
使用NOT EXISTS
SELECT Name as Customers from Customers c1 where not exists (select CustomerId from Orders o where c1.Id = o.CustomerId );
使用LEFT JOIN
select Name as Customers from Customers c1 left join Orders o on c1.Id = o.CustomerId where o.Id is NULL;
0 0
- MySQL-Customers Who Never Order
- Customers Who Never Order
- Customers Who Never Order
- Customers Who Never Order
- Customers Who Never Order
- Customers Who Never Order
- 题目7:MySQL----------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
- leetcode183-Customers Who Never Order
- 【Leetcode】Customers Who Never Order
- SQL-Customers Who Never Order
- 183. Customers Who Never Order
- 183. Customers Who Never Order
- 183. Customers Who Never Order
- 重温Http协议--请求报文和响应报文
- 动态规划
- 蓝桥杯 ADV-97 算法提高 十进制数转八进制数
- Missing styles. Is the correct theme chosen for this layout? Use the Theme combo box above the layou
- Error:java.lang.RuntimeException: Some file crunching failed, see logs for detail
- MySQL-Customers Who Never Order
- 蓝桥杯 ADV-98 算法提高 约数个数
- 前端开源项目周报0307
- 蓝桥杯 ADV-100 算法提高 第二大整数
- 蓝桥杯 ADV-102 算法提高 单词个数统计
- 经纬度解析地址传到后台
- extern "C"的作用
- SQL Server 截取字符串数组,获取字符串指定值
- eclipse 不能启动