题解 | #返回每个订单号各有多少行数#
返回每个订单号各有多少行数
https://www.nowcoder.com/practice/cf1f8d4a514d455aa0468718fb411f41
select order_num, count(order_num) as order_lines from OrderItems group by order_num order by order_lines
对统计数据进行条件输出,需要先将order_num分组,才能分组统计成功
返回每个订单号各有多少行数
https://www.nowcoder.com/practice/cf1f8d4a514d455aa0468718fb411f41
select order_num, count(order_num) as order_lines from OrderItems group by order_num order by order_lines
对统计数据进行条件输出,需要先将order_num分组,才能分组统计成功
相关推荐