MYSQL案例陈述的多个条件 [英] MYSQL CASE STATEMENT MULTIPLE CONDITIONS
本文介绍了MYSQL案例陈述的多个条件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
请帮助检查以下sql代码中的错误:
Please help to check the error in following sql code:
select
case when (z.mso_group_id = '3' and z.model_id = '22887081') then coalesce(level_2_id,996) level_2_id
when (z.mso_group_id = '4' and z.model_id = '22911859') then coalesce(level_2_id,997) level_2_id
when (z.mso_group_id = '5' and z.model_id = '22915074') then coalesce(level_2_id,998) level_2_id
when (z.mso_group_id = '2' and z.model_id = '22908275') then coalesce(level_2_id,999) level_2_id
end level_2_id
from
database_name
推荐答案
您正在重复列别名。您打算这样做吗?
You are repeating the column alias. Do you intend this?
select (case when (z.mso_group_id = '3' and z.model_id = '22887081') then coalesce(level_2_id,996)
when (z.mso_group_id = '4' and z.model_id = '22911859') then coalesce(level_2_id,997)
when (z.mso_group_id = '5' and z.model_id = '22915074') then coalesce(level_2_id,998)
when (z.mso_group_id = '2' and z.model_id = '22908275') then coalesce(level_2_id,999)
end) as level_2_id
from database_name;
这篇关于MYSQL案例陈述的多个条件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文