摘要： [转]sql case when then end 用法一．控制流程函数1．CASE value WHEN [compare-value] THEN result [WHEN [compare-value] THEN result ...] [ELSE result] END CASE WHEN [condition] THEN result [WHEN [condition] THEN result ...] [ELSE result] END该语句用于在不同情况时，执行不同的语句，实例如下：Eg1. SELECT CASE WHEN 1>0 THEN 'true' E 阅读全文