CTE的意思
「CTE」經常作為「Common Table Expression」的縮寫來使用,中文意思:「公用表表達式」。
CTE(公用表表達式)詳細解釋
- 英文縮寫詞:CTE
- 英文單詞:Common Table Expression
- 中文簡要解釋:公用表表達式
- 流行度:3495
- 分類:Computing
- 領域:Databases
英文縮寫CTE的擴展資料
- Its technical term is a common table expression ( CTE ).用技術術語來說,這叫做公共表表達式(commontableexpression,CTE)。
- The hierarchical query clause is not implemented as common table expression, but the clause is specified as part of a sub-select and must be specified after the WHERE, GROUP BY or HAVING clause.分級查詢子句不是作為公共表表達式來實現的,而是作為子句被指定為子SELECT語句的一部分,并且必須在指定WHERE、GROUPBY或HAVING子句之后指定。
- Instead data-change-operations shall be confined to the top level SELECT or the topmost SELECT of a common table expression ( CTE, also known as the " WITH clause ").相反,數據更改操作應該限制在公共表表達式(CTE,也叫做「WITH子句」)的頂層SELECT或最上面的SELECT中。
- According to the SQL Standard, the method to evaluate hierarchical or bi-directional data is the Recursive Common Table Expression(CTE) ( RCTE ).根據SQL標準,評估分層或雙向數據的方法為遞歸通用表表達式(RCTE)。
- This second select statement is joined with the Common Table Expression(CTE) ( CTE ) itself by linking parent to child data.第二個SELECT語句通過將父數據鏈接至子數據與公共表表達式(CTE)聯接。