LeetCode 183. Customers Who Never Order (从不订购的客户)
题目标签:
题目给了我们 Customers 和 Orders 两个表格,让我们找到 从没订购过的客户。
首先从Orders 得到 订购过的CustomerId,然后再去Customers 里找 没有出现过的 Id,返回名字。
Java Solution:
Runtime: 264 ms, faster than 53 %
Memory Usage: N/A
完成日期:06/01/2019
关键点:NOT IN
# Write your MySQL query statement below SELECT Customers.Name AS Customers FROM Customers WHERE Customers.Id NOT IN (SELECT CustomerId FROM Orders);
LeetCode 题目列表 - LeetCode Questions List
题目来源:https://leetcode.com/