leetcode 183. Customers Who Never Order

来源:互联网 发布:java maven 项目打包 编辑:程序博客网 时间:2024/05/17 08:49

题意:查找没有点过单的客人


题目链接:https://leetcode.com/problems/customers-who-never-order/


select Namefrom Customers as xwhere x.id not in (select distinct CustomerId                   from Orders);    


0 0
原创粉丝点击