====== CTE - Common Table Expression ======
  * View 와 비슷하지만 일회성.


===== MySQL CTE =====
  * 8.x 부터 지원됨.
  * [[https://dev.mysql.com/doc/refman/8.0/en/with.html|MySQL :: MySQL 8.0 Reference Manual :: 13.2.15 WITH (Common Table Expressions)]]
  * [[https://www.mysqltutorial.org/mysql-cte/|An Introduction to MySQL CTE]]


===== 참조 =====
  * [[https://www.sqlshack.com/sql-server-common-table-expressions-cte/|SQL Server Common Table Expressions (CTE)]]
  * [[https://yahwang.github.io/posts/49|SQL로 CTE를 표현하는 WITH 활용하기 - YA-Hwang 기술 블로그]]