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

两条 select

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

一条 select

select *
from OrderItems
where prod_id like "BNBG%" or quantity=100;