leetcode_sql_2,183
2024-09-09 03:36:08
183. Customers Who Never Order
Suppose that a website contains two tables, the Customers
table and the Orders
table. Write a SQL query to find all customers who never order anything.
Table: Customers
.
+----+-------+
| Id | Name |
+----+-------+
| 1 | Joe |
| 2 | Henry |
| 3 | Sam |
| 4 | Max |
+----+-------+
Table: Orders
.
+----+------------+
| Id | CustomerId |
+----+------------+
| 1 | 3 |
| 2 | 1 |
+----+------------+
Using the above tables as example, return the following:
+-----------+
| Customers |
+-----------+
| Henry |
| Max |
+-----------+
solutions:
SELECT A.Name from Customers A
LEFT JOIN Orders B on a.Id = B.CustomerId
WHERE b.CustomerId is NULL
SELECT A.Name from Customers A
WHERE NOT EXISTS (SELECT 1 FROM Orders B WHERE A.Id = B.CustomerId)
SELECT A.Name from Customers A
WHERE A.Id NOT IN (SELECT B.CustomerId from Orders B)
select c.Name from Customers c
where (select count(*) from Orders o where o.customerId=c.id)=0
最新文章
- SqlServer时间戳与普通格式的转换
- maven打包步骤_maven 构建项目
- int android.graphics.Bitmap.getRowBytes()
- Android TextView 显示不全的自动补齐方式
- java多线程解决生产者消费者问题
- Mysql-学习笔记(==》存储过程 九)
- UIWebView stringByEvaluatingJavaScriptFromString的使用方法
- ctypes 模块
- Zedboard甲诊opencv图像处理(三)
- 如何合并相同数据并转置(mysql)实现
- CursorAdapter说明
- Multimodal —— 看图说话(Image Caption)任务的论文笔记(一)评价指标和NIC模型
- Hibernate Annotation _List/Map
- 关于浏览器cookie的小知识
- Wireless Penetration Testing(7-11 chapter)
- LevelDB源码分析-编码
- python+django+uwsgi 搭建环境
- 更新快排中的partition
- Docker技术入门与实战 第二版-学习笔记-3-Dockerfile 指令详解
- JS在在线人数和访问人数
热门文章
- PHP......会话控制SESSION与COOKIE
- macOS 简单使用
- 转:C语言嵌入式系统编程之软件架构篇
- solr、Lucene、IKAnalyzer这三者关系是怎样的?
- Redis的分布式配置
- springboot-整合freemarker
- 快乐学习 Ionic Framework+PhoneGap 手册1-5 {IO开关}
- ACM训练小结-2018年6月15日
- 在IOS开发中,项目的目录结构如何搭建?
- INSPIRED启示录 读书笔记 - 第23章 改进现有产品