SQL Server：WITH 命令

WITH 命令用于为 SELECT 表达式返回的结果集定义别名。

实例

USE db_student;
WITH LOVE
AS
(SELECT * FROM course WHERE score > 8)
SELECT * FROM　LOVE