题解 | #返回每个订单号各有多少行数#
返回每个订单号各有多少行数
https://www.nowcoder.com/practice/cf1f8d4a514d455aa0468718fb411f41
SELECT order_num, COUNT(order_num) AS order_line FROM OrderItems GROUP BY order_num ORDER BY order_line; //如果有数字汇总,需要用count
返回每个订单号各有多少行数
https://www.nowcoder.com/practice/cf1f8d4a514d455aa0468718fb411f41
SELECT order_num, COUNT(order_num) AS order_line FROM OrderItems GROUP BY order_num ORDER BY order_line; //如果有数字汇总,需要用count
相关推荐