考察not in的用法
https://leetcode.com/problems/customers-who-never-order/
SELECT Name FROM Customers WHERE Id NOT IN (SELECT CustomerId FROM Orders)
本文介绍了一个使用NOT IN子句的SQL查询案例,该案例从Customers表中选取那些在Orders表中没有对应订单记录的客户的名字。
考察not in的用法
https://leetcode.com/problems/customers-who-never-order/
SELECT Name FROM Customers WHERE Id NOT IN (SELECT CustomerId FROM Orders)

被折叠的 条评论
为什么被折叠?