qq_19445777的博客

原创 where 多条件中取同时满足的写法

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)...