题解 | #将两个 SELECT 语句结合起来（二）#
将两个 SELECT 语句结合起来（二）
http://www.nowcoder.com/practice/ee9ef82f3d6f44b398aedc2fa71db612
两条 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;
现在要求你有实习经验，才让你实习！