如何連接這些列的結果作為最終結果：
SELECT
ID,
CASE
WHEN t1.SCORE <= 10 THEN '2A'
WHEN (t1.SCORE > 20 AND t1.SCORE <= 30) THEN '2B'
WHEN t1.SCORE > 30 THEN '2C'
END AS Result1,
CASE
WHEN t2.POINT <= 10 THEN '2A'
WHEN (t2.POINT > 20 AND t2.POINT <= 30) THEN '2B'
WHEN t2.POINT > 30 THEN '2C'
END AS Result2,
-- CONCAT(Result1,Result2) AS FinalResult
FROM
Table1 t1
INNER JOIN
Table2 t2 ON t2.CustomerID = t1.ID
如何添加這樣的運算式：
CONCAT(Result1, Result2) AS FinalResult
uj5u.com熱心網友回復：
將您的查詢包裝為派生表：
select Result1, Result2, CONCAT(Result1,Result2) AS FinalResult
from
(
SELECT ID,
CASE
WHEN t1.SCORE <= 10 THEN '2A'
WHEN (t1.SCORE > 20 AND t1.SCORE <= 30) THEN '2B'
WHEN t1.SCORE > 30 THEN '2C'
END AS Result1,
CASE
WHEN t2.POINT <= 10 THEN '2A'
WHEN (t2.POINT > 20 AND t2.POINT <= 30) THEN '2B'
WHEN t2.POINT > 30 THEN '2C'
END AS Result2
FROM Table1 t1 INNER JOIN Table2 t2 ON t2.CustomerID = t1.ID
) dt
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/381358.html
標籤：sql sql-server 查询语句
下一篇：當我應用過濾器查詢不起作用時，如何知道Where子句是否已經存在（如果存在），那么接下來用AND替換where嗎？