当前位置:首页 > 数据库 > 正文

19-9-30(数据库)

2020-03-01 数据库

https://leetcode-cn.com/problems/customers-who-never-order/

从不订购的客户

select Customers.Name as Customers from Customers where Customers.Id not in (select Orders.CustomerId from Orders);

个人理解:作为一个sql入门白痴,not in是个好东西

 

温馨提示: 本文由Jm博客推荐,转载请保留链接: https://www.jmwww.net/SQL/21356.html