05 2019 档案
select 中的逻辑判断 sql server
摘要：SELECT CASE field0010 WHEN '计划' THEN 1 ELSE 2 END AS s FROM formmain_5991 SELECT CASE WHEN (IFNULL(o.ENDTIME,99))=99 THEN (CASE WHEN (CURDATE()-pc.FORECASTTIME)>0 THEN (CASE W...
阅读全文