作者TeemingVoid (TeemingVoid)
看板Database
标题Re: [SQL ] CASE中符合条件的值才输出
时间Tue Aug 27 01:38:25 2013
你那样写应该可以啊... 请问是出现什麽错误讯息吗?
SELECT *,
REPLACE(RTRIM(
CASE WHEN A = 'Y' THEN 'A ' ELSE '' END +
CASE WHEN B = 'Y' THEN 'B ' ELSE '' END +
CASE WHEN C = 'Y' THEN 'C ' ELSE '' END +
CASE WHEN D = 'Y' THEN 'D ' ELSE '' END
), ' ', '+') AS [CHECK]
FROM YourTableName
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 114.38.86.24