[MySQL] Select 실행순서

문법순서

1. select   [ all | distinct ] ( * | col1 [ [ as ] "alias" ], col2, ... conN )
2. from    tablename
3. where   condition(조건)
4. group by
5. having
6. order by  col1, col2, col3 ... [ asc | desc ]
7. limit

---

실행 순서

1. from
2. on
3. join
4. where
5. group by
6. having
7. select
8. order by
9. limit