case when factsqy is NULL then '0' when factsqy is NOT NULL then factsqy end as factqtys

case  when factsqy is NULL  then '0' when factsqy is NOT NULL  then factsqy end as factqtys
原文地址:https://www.cnblogs.com/csj007523/p/1256471.html