SQL SELECT 문법/실행 순서 비교

 

No. 문법 실행
1

2

3

4

5

6

SELECT

FROM

WHERE

GROUP BY

HAVING

ORDER BY

FROM

WHERE

GROUP BY

HAVING

SELECT

ORDER BY

 

관련 예제

Outer Join (출처: JS’s Blog)