SQL 临时查询

2024-04-13 14:03:03 464

示例

它们的行为与嵌套子查询相同，但语法不同。

WITH ReadyCars AS (
  SELECT *
  FROM Cars
  WHERE Status = 'READY'
)
SELECT ID, Model, TotalCost
FROM ReadyCars
ORDER BY TotalCost;

ID模型总花费1福特F-1502002福特F-150230

等效子查询语法

SELECT ID, Model, TotalCost
FROM (
  SELECT *
  FROM Cars
  WHERE Status = 'READY'
) AS ReadyCars
ORDER BY TotalCost