努力拼一把

题解

读书笔记(1)

/ 注册

全部文章 / 题解（共1篇）

题解 | #返回订单数量总和不小于100的所有订单的订单号#

SELECT a.order_num FROM (SELECT order_num,SUM(quantity)AS num FROM OrderItems GROUP BY order_num)AS a WHERE num>100 ORDER BY a.order_num; 可用子查询先将符合...

Mysql

2022-06-24

0 272