case when LOT_OUT_STATE!='Outsource' then '数据校验失败'
when (LOT_ID='' or LOT_ID is null) then '未找到LOT ID'
when returncount<WAFER_QTY then '未完全回货'
else 'xxx'
end remark
这里remark是栏位的别名,这个与SQL server(end case)不一样
case when LOT_OUT_STATE!='Outsource' then '数据校验失败'
when (LOT_ID='' or LOT_ID is null) then '未找到LOT ID'
when returncount<WAFER_QTY then '未完全回货'
else 'xxx'
end remark
这里remark是栏位的别名,这个与SQL server(end case)不一样