CTE

CTE (Common Table Expression)，通用資料表運算式，在Oracle又稱為Subquery Factoring（子查詢分解）

• 參照：『維基百科～Common_table_expression』

技術文件

• WITH common_table_expression (Transact-SQL) - SQL Server | Microsoft Learn
• MySQL :: MySQL 8.0 Reference Manual :: 13.2.15 WITH (Common Table Expressions)
• PostgreSQL: Documentation: 15: 7.8. WITH Queries (Common Table Expressions)
• ORACLE-BASE - WITH Clause : Subquery Factoring in Oracle

FAQ

那些資料庫支援CTE

• Teradata (starting with version 14)
• IBM Db2, Informix (starting with version 14.1)
• Firebird (starting with version 2.1)
• Microsoft SQL Server (starting with version 2005)
• Oracle (with recursion since 11g release 2)
• PostgreSQL (since 8.4)
• MariaDB (since 10.2)
• MySQL (since 8.0)
• SQLite (since 3.8.3)
• HyperSQL
• Informix (since 14.10)
• Google BigQuery
• Sybase (starting with version 9)
• Vertica
• H2 (experimental)