[DataBase] SELECT 쿼리 실행 순서

SELECT 쿼리 작성 순서

1. SELECT

2. FROM 

3. WHERE 

4. GROUP BY 

5. HAVING

6. ORDER BY  

 

SELECT 쿼리 실행 순서

1. FROM

2. ON

3. JOIN

4. WHERE

5. GROUP BY

6. HAVING

7. SELECT

8. DISTINCT

9. ORDER BY

10. TOP