MySql中case...when...的用法

SELECT

(CASE WHEN ( xyz.字段1 IS NULL ) THEN '未监控'

WHEN ( xyz.字段1 is not null and (xyz.字段2 = 0 or xyz.字段2 is null) ) THEN '0'

WHEN ( xyz.字段1 is not null and xyz.字段2 > 0 AND xyz.字段2 <= 0.15 ) THEN '0%-15%'

...

...

WHEN ( xyz.字段1 is not null and xyz.字段2 > 0.6 AND xyz.字段2 <= 0.85 ) THEN '60%-85%'

ELSE '85%-100%' END ) AS xxx

FROM

a_b_c abc

LEFT JOIN x_y_z xyz ON abc.id = xyz.id

and abc.属性1 in

#{item}

AND abc.属性2 in

#{item}

AND abc.属性3 in

#{item}

©著作权归作者所有：来自51CTO博客作者zjy666的原创作品，如需转载，请注明出处，否则将追究法律责任