您可以为公用表表达式创建嵌套的WITH子句吗? [英] Can you create nested WITH clauses for Common Table Expressions?

问题描述

WITH y AS (
    WITH x AS (
        SELECT * FROM MyTable
    )
    SELECT * FROM x
)
SELECT * FROM y

类似的东西行吗?我之前尝试过，但无法正常工作.

Does something like this work? I tried it earlier but I couldn't get it to work.

推荐答案

虽然不是严格嵌套的，但您可以使用公用表表达式在后续查询中重用先前的查询.

While not strictly nested, you can use common table expressions to reuse previous queries in subsequent ones.

为此，您要查找的语句形式为

To do this, the form of the statement you are looking for would be

WITH x AS 
(
    SELECT * FROM MyTable
), 
y AS 
(
    SELECT * FROM x
)
SELECT * FROM y

这篇关于您可以为公用表表达式创建嵌套的WITH子句吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！