题解 | 将两个 SELECT 语句结合起来(一)
select * from ( select prod_id, quantity from OrderItems where quantity = 100 union all select prod_id, quantity from OrderItems where prod_id like 'BNBG%' ) a order by prod_id asc
select * from ( select prod_id, quantity from OrderItems where quantity = 100 union all select prod_id, quantity from OrderItems where prod_id like 'BNBG%' ) a order by prod_id asc
相关推荐