题解 | #将两个 SELECT 语句结合起来（一）#
将两个 SELECT 语句结合起来（一）
https://www.nowcoder.com/practice/a33d5c0ebf434e00b22e2977a5aa3a90
输入：
DROP TABLE IF EXISTS `OrderItems`;
CREATE TABLE IF NOT EXISTS `OrderItems`(
prod_id VARCHAR(255) NOT NULL COMMENT '产品id',
quantity VARCHAR(255) NOT NULL COMMENT '商品数量'
);
INSERT `OrderItems` VALUES ('a0001',105),('a0002',100),('a0002',200),('a0013',1121),('a0003',10),('a0003',19),('a0003',5),('BNBG',10002);
(SELECT * FROM OrderItems WHERE quantity = 100 ) union (SELECT * FROM OrderItems WHERE prod_id LIKE 'BNBG%') order by prod_id
输出：
投递强生等公司6个岗位 >
