SQLD · 모의고사 8회 · 29번

Question

JOIN, DISTINCT, LIMIT이 포함된 SQL SELECT 문의 논리적 처리 순서로 옳은 것은?

Accepted Answer

FROM과 JOIN → WHERE → GROUP BY → HAVING → SELECT → DISTINCT → ORDER BY → LIMIT

Answer

FROM과 JOIN → WHERE → GROUP BY → SELECT → HAVING → DISTINCT → ORDER BY → LIMIT

Answer

SELECT → DISTINCT → FROM과 JOIN → WHERE → GROUP BY → HAVING → ORDER BY → LIMIT

Answer

FROM과 JOIN → GROUP BY → WHERE → HAVING → SELECT → ORDER BY → DISTINCT → LIMIT