它只返回EIA的值,而不返回EIA 2 的值
(
case
when tc.name = 'EIA' then tor.value else null
end
) as EIA,
(
case
when tc.name = 'EIA 2' then tor.value else null
end
) as EIA2
这就是这个表结构
测试执行的Tor值EIA,EIA 2阳性,阳性
ID Name EIA EIA 2
1 John POSITIVE no values??
试试这个:
(
CASE
WHEN tc.name IS NULL THEN '' WHEN tc.name = 'EIA' THEN tor.value
END
) as EIA,
(
CASE
WHEN tc.name IS NULL THEN '' WHEN tc.name = 'EIA 2' THEN tor.value
END
) as EIA2
(CASE
WHEN tc.name = 'EIA' THEN tor.value
WHEN tc.name = 'EIA 2' THEN tor.value
ELSE NULL
END)
或
(CASE
WHEN tc.name = 'EIA' THEN tor.value
END) as EIA,
(CASE WHEN tc.name = 'EIA 2' THEN tor.value
END) as EIA2