执行顺序

 

执行顺序

FROM -> WHERE -> GROUP BY -> HAVING -> SELECT -> DISTINCT -> UNION -> ORDER BY -> limit
 1        2         3          4         5          6          7         8          9