where 多条件中取同时满足的写法
下面是个小例子:
select * from dw.stores_info a where a.store_name like ‘%新%’ and 1 = (case when a.purchase_type = 3 and a.delivery_type = 1 then 0 else 1 end)
下面是个小例子:
select * from dw.stores_info a where a.store_name like ‘%新%’ and 1 = (case when a.purchase_type = 3 and a.delivery_type = 1 then 0 else 1 end)