Recursive Common Table Expression – RCTE
递归通用表表达式 (RCTE)
Its technical term is a common table expression (CTE).
用技术术语来说,这叫做公共表表达式(common table expression,CTE)。
Notice that for each repetition group a common table expression has been created (lines 2, 18 and 38).
注意,已为每个副本组创建了一个公共表表达式(第2、18和38行)。
This second select statement is joined with the Common Table Expression (CTE) itself by linking parent to child data.
第二个SELECT语句通过将父数据链接至子数据与公共表表达式 (CTE) 联接。
According to the SQL Standard, the method to evaluate hierarchical or bi-directional data is the Recursive Common Table Expression (RCTE).
根据SQL标准,评估分层或双向数据的方法为递归通用表表达式(RCTE)。
Table 1 shows some common regular expression operators.
表1显示了一些常用的正则表达式操作符。
Table 1 shows some common regular expression operators.
表1显示了一些常用的正则表达式操作符。
应用推荐