题解 | #返回更多的产品#
返回更多的产品
https://www.nowcoder.com/practice/dc91b7d2de3c4603a55995e83210f605
-- 首先去重distinct 产品数量需要大于100 select distinct order_num from OrderItems where quantity >100 order by order_num;
去重使用distinct。用法是 select distinct 字段名 。
返回更多的产品
https://www.nowcoder.com/practice/dc91b7d2de3c4603a55995e83210f605
-- 首先去重distinct 产品数量需要大于100 select distinct order_num from OrderItems where quantity >100 order by order_num;
去重使用distinct。用法是 select distinct 字段名 。
相关推荐