183. Customers Who Never Order
来源:互联网 发布:compendex数据库 编辑:程序博客网 时间:2024/06/11 13:46
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 |+-----------+
使用左外连接 然后使用条件语句
# Write your MySQL query statement belowSELECT C.Name Customers FROM Customers C LEFT JOIN Orders O ON C.Id=O.CustomerId WHERE O.CustomerId IS NULL;
使用NOT IN
# Write your MySQL query statement belowSELECT C.Name Customers FROM Customers C WHERE C.Id NOT IN (SELECT CustomerId FROM Orders);
0 0
- 183. Customers Who Never Order
- 183. Customers Who Never Order
- 183. Customers Who Never Order
- 183. Customers Who Never Order
- 183. Customers Who Never Order
- 183. Customers Who Never Order
- 183. Customers Who Never Order
- 183. Customers Who Never Order
- Customers Who Never Order
- Customers Who Never Order
- Customers Who Never Order
- Customers Who Never Order
- 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
- C#基础语言知识--编译和执行过程(二)
- Java获取路径方式
- 第12周项目1-实现复数类中的运算符重载
- 【C++】三大特征之多态性(运算符重载)
- Freemarker使用之List
- 183. Customers Who Never Order
- WPS中公式标注与公式居中对齐
- Java基础-父类对象对子类对象的引用
- 母函数有感(学习总结)
- 程序员容易发福的原因及解决办法
- 平台搭建2:ubuntu12.04下安装freesurfer
- css 表格
- Android和Java中的回调函数
- Duilib学习笔记《04》— 窗体显示