WITH是临时的结果集的命名跟AS搭配使用,称为公用表表达式 (CTE): WITH a(n,b) AS (SELECT [name],balance FROM bankaccounts) SELECT * FROM a;