关键字是按照如下顺序进行执行的:Where, Group By, Having, Order by。 FROM WHERE (先过滤单表/视图/结果集,再JOIN) GROUP BY HAVING (WHERE过滤的是行,HAVING过滤的是组,所以在GROUP之后) ORDER BY