避免SQL Server SELECT语句中的计算列代码重复

SELECT column1, column2, 
       (SELECT MAX(salary) FROM employees) AS max_salary
FROM employees;

WITH cte AS (
   SELECT MAX(salary) AS max_salary
   FROM employees
)
SELECT column1, column2, max_salary
FROM employees, cte;

CREATE TABLE #temp (
   max_salary INT
);

INSERT INTO #temp
SELECT MAX(salary)
FROM employees;

SELECT column1, column2, max_salary
FROM employees, #temp;

DROP TABLE #temp;

CREATE TABLE employees (
   column1 INT,
   column2 INT,
   salary INT,
   max_salary AS (SELECT MAX(salary) FROM employees)
);

SELECT column1, column2, max_salary
FROM employees;