选择产品A和B组合的订单

让我把你的问题解释为想要特定的产品对。如果是,您可以使用 group by 和 having . 假设您的数据中没有重复项:

select o.order_id
from orders o 
group by o.order_id
having sum(case when o.product in ('A', 'B') then 1 else 0 end) = 2 or
       sum(case when o.product in ('C', 'D') then 1 else 0 end) = 2 or
       sum(case when o.product in ('X', 'Y') then 1 else 0 end) = 2;

如果你想要的订单 二 然后添加条件 count(*) = 2。或者,如果你想变得深奥,你可以改变 else 像这样的 else 10 .

如果您的表数据

| ORDER_ID | PRODUCT_NAME | PRODUCT |
|----------|--------------|---------|
|        1 |        xxx01 |     A、B |
|        2 |        xxx02 |     B、C |
|        3 |        xxx03 |     C、D |
|        4 |        xxx04 |     D、X |
|        5 |        xxx05 |     E、Z |

尝试此脚本:

select order_id,product_name ,product
from orders 
where product like ('%A%B%') 
or product like ('%C%D%') 

如果您的表数据像;

| ORDER_ID | PRODUCT_NAME | PRODUCT |
|----------|--------------|---------|
|        1 |        xxx01 |       A |
|        1 |        xxx02 |       B |
|        2 |        xxx03 |       C |
|        2 |        xxx04 |       D |
|        3 |        xxx05 |       E |

尝试此脚本:

select order_id
from orders 
group by order_id having   
  count( case when product in ('A','B') then 1 else null end  ) > 1
  or 
  count( case when product in ('C','D') then 1 else null end  ) > 1