题解 | #返回每个订单号各有多少行数#
SELECT
Order_num,
COUNT(order_num) AS order_lines
FROM
OrderItems
GROUP BY
order_num
ORDER BY
order_lines ASC
SELECT
Order_num,
COUNT(order_num) AS order_lines
FROM
OrderItems
GROUP BY
order_num
ORDER BY
order_lines ASC
相关推荐