題解 | #糾錯3#
糾錯3
http://www.fangfengwang8.cn/practice/3870c9bca7a4406f899af3e903b8bf51
SELECT order_num, COUNT(*) AS items FROM OrderItems GROUP BY order_num HAVING items >= 3 ORDER BY items, order_num;
1.group by中必須包含select語句中的非聚合函數(shù)
糾錯3
http://www.fangfengwang8.cn/practice/3870c9bca7a4406f899af3e903b8bf51
SELECT order_num, COUNT(*) AS items FROM OrderItems GROUP BY order_num HAVING items >= 3 ORDER BY items, order_num;
1.group by中必須包含select語句中的非聚合函數(shù)
相關推薦