sql - 如何在 DB2 查询中打印“TEST PASSED”

Question

请问，如何添加IF_ELSE或CASE语句，打印出IF TEST PASSED或FAILED的答案？

-- 每个参数都应该 1:1 匹配

-- 如果结果为 0 ---> "TEST PASSED"

-- 否则 ---> “测试失败”

select COUNT(*) AS RESULT from (
SELECT 
distinct T1.PROJECT_NO,
T1.START,
D.DATE,
T1.STATUS

FROM TEAM AT
JOIN PROJECT T1
ON AT.GROUP_ID = T1.ROW_ID 
AND T1.MARKED <> 'Y'
JOIN TRIP D
ON T1.ROW_ID = D.ROW_ID
AND D.MARKED <> 'Y'
where STATUS in ('active')

INTERSECT

select L.PROJECT_NO, L.START, L.DATE, 'active' as STATUS 
from TARGET_TABLE L with ur );

非常感谢您的每一个回复。

标签： sqldatabasedb2

Answer 1

使用CASE：

SELECT CASE count(*)
         WHEN 0 THEN
           'TEST PASSED'
         ELSE
           'TEST FAILED'
       END RESULT
       ...