分析

关键词：having

用法：

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

代码

select order_num
from OrderItems
group by order_num
having sum(quantity)>=100
order by order_num