[sql] 구문(where, group by 등)의 실행 순서

순서: 

1. FROM 2. ON 3. JOIN 4. WHERE 5. GROUP BY 6. WITH CUBE or WITH ROLLUP 7. HAVING 8. SELECT 9. DISTINCT 10. ORDER BY 11. TOP

 

자주 쓰는것 들: 

1. WHERE 2. GROUP BY 3. HAVING 4. DISTINCT 5.ORDER BY