[SQL] SQL Query 실행 순서

SELECT DISTINCT column_1, column_2
FROM table_1
JOIN table_2
ON table_1.column_1 = table_2.column_1
WHERE table_1.column_2 > 100 -- constraint_expression
GROUP BY table_1.conlumn_1 -- column
HAVING COUNT(table_1.column_1) > 1  -- constraint_expression
ORDER BY table_1.conlumn_1 ASC
LIMIT count;

 

실행순서

 

FROM > JOIN > ON > WHERE > GROUP BY > HAVING > SELECT > DISTINCT > ORDER BY > LIMIT