题解 | #纠错3#

纠错3

https://www.nowcoder.com/practice/3870c9bca7a4406f899af3e903b8bf51

SELECT order_num, COUNT(*) AS items 
FROM OrderItems 
GROUP BY  order_num
HAVING items >= 3  order by order_num , items 先对order_num进行分组,然后条件过滤

全部评论

相关推荐

求面试求offer啊啊啊啊:这个在牛客不是老熟人了吗
点赞 评论 收藏
分享
评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客企业服务