글 작성자: nouu

https://sqlbolt.com/lesson/select_queries_order_of_execution

 

SQLBolt - Learn SQL - SQL Lesson 12: Order of execution of a Query

Now that we have an idea of all the parts of a query, we can now talk about how they all fit together in the context of a complete query. Complete SELECT query SELECT DISTINCT column, AGG_FUNC(column_or_expression), … FROM mytable JOIN another_table ON m

sqlbolt.com

 

SQL 작성 순서와 실행 순서는 다르다. 실행 순서를 유념하여 쿼리를 작성하는 것은 매우매우매우매우 중요하다.