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

select prod_id,quantity
from OrderItems  
where quantity = 100
union all 
select prod_id,quantity
from OrderItems  
where prod_id like 'BNBG%'
order by prod_id