leetcode sql No.183 从不订购的客户

最新推荐文章于 2022-03-22 09:39:38 发布

零分分分分

最新推荐文章于 2022-03-22 09:39:38 发布

阅读量114

点赞数

分类专栏： leetcode sql

本文链接：https://blog.csdn.net/qq_33399567/article/details/92796690

版权

leetcode sql 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

select t0.name as Customers  from Customers t0 where not exists (select * from orders t1  where t0.id=t1.customerid)

高赞解法 左连接： select Name as Customers from Customers left join Orders on Customers.Id = Orders.CustomersId where Orders.CustomerId is null

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

零分分分分

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
leetcode sql No.183 从不订购的客户

select t0.name as Customers from Customers t0 where not exists (select * from orders t1 where t0.id=t1.customerid)高赞解法左连接： select Name as Customers from Customers left join Orders on Customers.Id...
复制链接

扫一扫