分析

关键词：where，distinct(去重）

用法：select distinct [列名] from [表名] where 判断条件 order by ..

代码

select distinct order_num
from OrderItems
where quantity>=100