sql - 客户列表 IN 和 NOT IN

Question

如何获得在 7/31 之前属于某个类别但在 8/1 之前没有的客户编号？

select customer_number
from table 
where
purchased = 'a'
and date = '07-31-2020'

假设我有 2020 年 8 月 31 日之前的数据。

我想获取在 7/31 之前购买了“a”但之后没有购买的客户编号列表

标签： sql

Answer 1

你可以试试下面的 -

select customer_number 
from table where purchased = 'a' 
group by customer_number
having max(date)='07-31-2020'