题解 | #返回每个订单号各有多少行数#
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
相关推荐
查看13道真题和解析
程序员花海_:实习和校招简历正确格式应该是教育背景+实习+项目经历+个人评价 其中项目经历注意要体现业务 实习经历里面的业务更是要自圆其说 简历模板尽可能保持干净整洁 不要太花哨的