WITH y AS WITH x AS SELECT * FROM MyTable ) SELECT * FROM x)SELECT * FROM y像这样的工作吗?我早就尝试过,但不能正常工作。$ }9 e7 I' V T6 p& {2 T
" _' u7 r& Q, f, E0 x 解决方案: " D% `- F# _" s
虽然不严格嵌套,但可以在后续查询中使用公共表达式重用以前的查询。( S. R( l/ l9 T( }- Z. k
为此,你想找到的句子形式是1 d y9 T( ?/ X9 b0 s7 ^
WITH x AS SELECT * FROM MyTable),y AS SELECT * FROM x)SELECT * FROM y