-----错误判断------------------------------------------------------------------------------------
SELECT
policy_jq_no,policy_sy_no,
CASE policy_jq_no
WHEN '' THEN
policy_sy_no
ELSE
policy_jq_no
END policy_no
FROM
ZY_SURVEY_VISIT order by FLOW_ID desc
![](https://images2015.cnblogs.com/blog/625305/201702/625305-20170219193914066-329987679.png)
---正确判断-----------------------------------------------------------------------------
SELECT
policy_jq_no,policy_sy_no,
CASE
WHEN policy_jq_no IS NULL THEN
policy_sy_no
ELSE
policy_jq_no
END policy_no
FROM
ZY_SURVEY_VISIT order by FLOW_ID desc
![](https://images2015.cnblogs.com/blog/625305/201702/625305-20170219193941613-160718981.png)
一步一步行走,做好每一件事情。