leetcode 183. Customers Who Never Order
来源:互联网 发布:java可以多继承吗 编辑:程序博客网 时间:2024/06/05 04:44
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 |+-----------+
又是一道水题 考察的是not in的应用
# Write your MySQL query statement below
select name as Customers from Customers where id not in (select c.id from Customers c inner join Orders o on c.id=o.CustomerId ) 0 0
- 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
- 183. Customers Who Never Order (LeetCode, SQL)
- 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
- 183. Customers Who Never Order
- 183. Customers Who Never Order
- StringUtils工具类的常用方法
- 电容器的电介质吸收(DA)现象
- (ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY)讲解
- Android使用脚本多渠道打包
- 写在前面的话
- leetcode 183. Customers Who Never Order
- 自定义控件,上图下字的Button,图片任意指定大小
- 优先队列
- 匿名内部类需要注意的事项
- 51nod 1257 背包问题 V3(二分)
- 设置字体大小px、em和rem区别
- Eclipse使用技巧(更新)
- Ubuntu+Apache+PHP+Mysql环境搭建(完整版)
- Django——成绩管理系统部署及应用