分析

关键词：having

用法：

  • where---过滤过滤指定的行
  • having--过滤分组，与group by连用

代码

SELECT order_num, COUNT(*) AS items 
FROM OrderItems 
GROUP BY order_num
HAVING items >= 3 
ORDER BY items, order_num;