如何在SQL Server的From部分中给出case when语句值

SELECT *
FROM (
    SELECT column1, column2, 
        CASE 
            WHEN condition1 THEN value1
            WHEN condition2 THEN value2
            ELSE value3
        END AS new_column
    FROM your_table
) AS subquery
WHERE new_column = 'some_value';

WITH cte AS (
    SELECT column1, column2, 
        CASE 
            WHEN condition1 THEN value1
            WHEN condition2 THEN value2
            ELSE value3
        END AS new_column
    FROM your_table
)
SELECT *
FROM cte
WHERE new_column = 'some_value';