mysql中先执行where还是group by

having可以用聚合函数，如having sum(money) > 1000

1. SELECT user_type,is_admin ,SUM(id) FROM saut_m_user
2. WHERE id > 100
3. GROUP BY user_type,is_admin
4. HAVING SUM(status) < 500
5. ORDER BY is_admin ASC

    

    

mysql中先执行where还是group by

标签：通过   rom   UNC   mysq   func   type   where   根据   数据