题解 | #将两个 SELECT 语句结合起来（一）#

select prod_id, quantity
from OrderItems oi
where quantity=100
union
select prod_id, quantity
from OrderItems oi
where prod_id like binary 'BNBG%';