SQL select 쿼리 문법 순서

1. FROM

2. ON

3. JOIN

4. WHERE

5. GROUP BY

6. CUBE | ROLLUP

7. HAVING

8. SELECT

9. DISTINCT

10. ORDER BY

11. TOP

 

- FROM GROUP BY HAVING SELECT

- FROM ON JOIN WHERE SELECT DISTINCT ORDER BY

 

- SELECT, ORDER BY는 나중에 실행된다

- JOIN을 사용했을 때 FROM ON JOIN WHERE 순서로 실행한다.

 

출처 : https://bicloud.tistory.com/20